ER diagram

draw the ER diagram in lucid chart or any other software. here is the question

CSC 134 Fall 2021 Assignment 1
Draw an ER diagram accordingly to the following user requirements. You can draw the diagram
using tools that you prefer, such as Microsoft Visio, Microsoft Word, Microsoft Power Point.
Hand-drawn diagram will get a Zero. Please use the ER notation taught in this class to complete
this assignment. Using any other ER notation will get a Zero. Please don’t use non-binary
relationship in this assignment. Please submit a PDF file to Canvas. List assumptions for your
diagram, if there is any.
A database is gathering the following information:
•
Doctors are uniquely identified by their SSNs. For each doctor, the name, specialty
must be recorded.
▪
Each pharmaceutical company is identified by a unique name and has a phone
number.
▪
For each drug, the drug name and formula must be recorded. Each drug is
manufactured by a pharmaceutical company, and drug name identifies a drug
uniquely from among the products of that company. The name is unique only
regarding the same pharmaceutical company. For example, name of “Ibuprofen” can
be produced by different pharmaceutical companies.
▪
Each pharmacy has a unique name, address and phone number. 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 can make many prescriptions. Each prescription has a unique number with
regard to a doctor. For example, Dr. Smith can produce prescription number 328. Dr.
Miller can produce prescription number 328. Because the they are from different
doctors, these two prescriptions can be distinguished in the database.
The
prescription date is also recorded. Please make this date as an attribute of your entity,
instead of an attribute of relationship.
▪
A prescription is made by one and only one doctor.
▪
Each prescription includes at least one drug. A drug may not be in any prescription.
A drug may be in different prescriptions.
▪
One drug can be sold by many pharmacies and one pharmacy can sell many drugs.
Some drugs may not be sold by any pharmacy.
▪
One drug can be made by one pharmaceutical company where as a pharmaceutical
company can make many drugs.
▪
Each pharmacy must sell at least one drug.