Question: please draw ER diagram for pharmacy database application You are asked to design a pharmacy database application for a chain of pharmacies with the following

please draw ER diagram for pharmacy database application  please draw ER diagram for pharmacy database application You are asked

You are asked to design a pharmacy database application for a chain of pharmacies with the following requirements. There are three main items in the database: pharmaceutical companies, pharmacies, and drugs. Each pharmaceutical company is uniquely identified by its name and has one or more phone numbers. For each drug, the trade name and formula must be redecorated. Each drug is produced by a pharmaceutical company, and trade name identifies a drug uniquely from among products of that company. If the pharmaceutical company is deleted, you no longer need to keep track of its products. A drug many course allergy (bad side effect) for a given patient if it is taken with other drugs (i.e., a given drug should not be taken with these drugs.) For each drug, the database should maintain all allergic drugs (if any) that may cause allergy if they are taken with the specified drug. Each pharmacy has a name, address as (city, state, and P.O. Box), and a phone number. It is uniquely identified by its name and address. Each pharmacy sells several drugs, and has a price for each. A drug could be sold at several pharmacies, companies have long term contracts with several pharmacies, and a pharmacy can haves contracts with several pharmaceutical companies. For each contract, you need to store the start day and end date. Design an ER diagram for the application. You need to specify all entity types, attributes, relationships, maximum and minimum cardinalities, and other applicable constraints. Also, you need to justify your decisions and state additional assumptions if necessary: Specify the main entities with their attributes. Specify the main relationships with the main relationship with their constraints and participating entities

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!