Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions

Question

Approaches to Managing Organizations

Answered: 1 week ago

Question

b. Will there be one assigned leader?

Answered: 1 week ago

Question

Do you currently have a team agreement?

Answered: 1 week ago