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 SSNSS. 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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

answer this question in lucid chart or any other software ?? 

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.
Jin, Ying
Deleted: trade
For each drug, the drug_name and formula must be recorded. Each drug is
manufactured by
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.
Transcribed Image Text: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. Jin, Ying Deleted: trade For each drug, the drug_name and formula must be recorded. Each drug is manufactured by 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.
Transcribed Image Text:Each pharmacy must sell at least one drug.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education