Answer Happy

Case Study about Pharmacy Information System (PHRIS). The KENAGA chain of pharmacies has offered to give you a free life-time supply of medicines if you design its database for Pharmacy Information System (PHRIS). Given the rising cost of health care, you agree. Here is the information that you gather. • Patients are identified by SSN, and their names, addresses, and also ages. • Doctors are identified by an SSN, for each doctor, the name, specialty and years of experience must be recorded. • Each pharmaceutical company is identified by name and has a phone number. • For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company is deleted, you need not keep track of its products any longer. • Each pharmacy has a name, address, and phone number. • Every patient has a primary physician. Every doctor has at least one patient. • Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another. • Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity associated with it. You can assume that if a doctor prescribes the same drug for the same patient more than once, only the last such prescription needs to be stored. • Pharmaceutical companies have long-term contracts with pharmacies. A pharmaceutical company can contract with several pharmaceutical companies. For each contract, you have to store a start date, and end date, and the text of the contract. • Pharmacies appoint a supervisor for each contract. There must always a supervisor for each contract. Draw a LOGICAL ENTITY RELATIONSHIP DIAGRAM that captures the above information by using UML NOTATION. Please identify the primary key, foreign key, attributes, relationships and cardinality of the diagram.