[ARCHIVED] DBMS

[ShilikomwenyoNa]

Pharmaceutical Manufacturing Companies in Namibia such as Medipark Pharmaceutical Wholesaler (Pty) Ltd, Oshana Pharmacy CC, Fabupharm Pty LTD etc, would like to have a database that gives data about the available drugs, pharmacies, prescriptions written to patients by doctors and prepared by physician, supplying pharmaceutical companies, contracts between different companies and pharmacies, etc. Below is a narration of some data requirements for a series of pharmacies. Draw a suitable Entity Relationship Diagram (ERD) Clearly indicate all relationships, cardinality constraints and appropriate attributes.

• The pharmaceutical company produces one or more drugs, and each drug is produced and merchandised by exactly one pharmaceutical company.
• Drugs are sold in pharmacies. Each pharmacy has a unique Identify. Every pharmacy sells one or more drugs, but some pharmacies do not sell every drug.
• Drug sales must be recorded by prescription, which are kept as a record by the pharmacy. A prescription clearly identifies the drug, physician, and patient, as well as the date it is filled.
• Doctors prescribe drugs for patients. A doctor can prescribe one or more drugs for a patient and a patient can get one or more prescriptions, but a prescription is written by only one doctor.
• Pharmaceutical companies may have long-term contracts with pharmacies and a pharmacy can contract with zero, one, or more pharmaceutical companies. Each contract is uniquely identified by a contract number.

[kmeeusen · Accepted solution]

Hi @ShilikomwenyoNa 

You may not realize it, but you have posted this in a global community of Canvas users. The Canvas Community is a collaborative space where community members go to Find Answers, Join Groups, and Share Ideas, and much more.

Your posting looks like it was intended to be some form of an assignment submission for a course, most likely a discussion posting. If so, you have most definitely posted in the wrong place. While we welcome student participation in this community, your posting here will not get you credit in your course, and is very likely not even seen by your instructor.

Please contact your instructor to learn where you should have posted.

Good luck,

Kelley

PS: I used to teach Pharmacology! Good stuff!