Question 2 for a new chain of pharmacies with the following specifications: Utilize the different concepts we discussed to design a database (single ER diagram) 1. Patients are identified by SSN (Social Security Number), and the name, address, and age must be recorded for each patient. 2. Doctors are identified by SSN, and the names, specialties, and years of experience must be recorded for each doctor. 3. Every patient has a doctor, and every doctor has at least one patient. 4. Each pharmaceutical company is identified by name and has more than one phone number. 5. For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies the drug from the others of that company. If a pharmaceutical company is deleted, you need not keep track of its drugs any longer. 6. Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity associated with it. 7. Each macy has a name, address, and phone number. 8. Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies. 9. Pharmaceutical companies have contracts with pharmacies. A pharmaceutical company can contract several pharmacies, and a pharmacy can contract several pharmaceutical companies. For each contract, you have to store a start date, an end date, and the text of the contract.
Question 2 for a new chain of pharmacies with the following specifications: Utilize the different concepts we discussed to design a database (single ER diagram) 1. Patients are identified by SSN (Social Security Number), and the name, address, and age must be recorded for each patient. 2. Doctors are identified by SSN, and the names, specialties, and years of experience must be recorded for each doctor. 3. Every patient has a doctor, and every doctor has at least one patient. 4. Each pharmaceutical company is identified by name and has more than one phone number. 5. For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies the drug from the others of that company. If a pharmaceutical company is deleted, you need not keep track of its drugs any longer. 6. Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity associated with it. 7. Each macy has a name, address, and phone number. 8. Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies. 9. Pharmaceutical companies have contracts with pharmacies. A pharmaceutical company can contract several pharmacies, and a pharmacy can contract several pharmaceutical companies. For each contract, you have to store a start date, an end date, and the text of the contract.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter9: Database Design
Section: Chapter Questions
Problem 7P
Related questions
Question
Transcribed Image Text:Question 2
for a new chain of pharmacies with the following specifications:
Utilize the different concepts we discussed to design a database (single ER diagram)
1. Patients are identified by SSN (Social Security Number), and the name, address, and age must be
recorded for each patient.
2. Doctors are identified by SSN, and the names, specialties, and years of experience must be recorded
for each doctor.
3. Every patient has a doctor, and every doctor has at least one patient.
4. Each pharmaceutical company is identified by name and has more than one phone number.
5. For each drug, the trade name and formula must be recorded. Each drug is sold by a given
pharmaceutical company,
pharmaceutical company is deleted, you need not keep track of its drugs any longer.
6. Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients,
and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity
associated with it.
and the trade name identifies the drug from the others of that company. If a
7. Each pharmacy has a name, address, and phone number.
8. Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies.
9. Pharmaceutical companies have contracts with pharmacies. A pharmaceutical company can contract
several pharmacies, and a pharmacy can contract several pharmaceutical companies, For each contract,
you have to store a start date, an end date, and the text of the contract.
Expert Solution
Step 1
Entity Relationship diagram will show the relationship among entity sets. An entity set is a group of similar entities and these entities can have attributes. In terms of DBMS, an entity is a table or attribute of a table in database, so by showing relationship among tables and their attributes, ER diagram shows the complete logical structure of a database.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning