• Patients are identified by an SSN, and their names, addresses, and dob must be recorded. • Doctors are identified by an SSN. For each doctor, the name, specialty, and years of experience must be recorded. • Each pharmaceutical company is identified by name and has a phone number. • 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 a drug uniquely from among the products of that company. • Each pharmacy has a name, address, and phone number. • Every patient has one primary physician. • 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 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. • Pharmaceutical companies have long-term contracts with pharmacies. A pharmaceutical company can contract with several pharmacies, and a pharmacy can contract with several pharmaceutical companies. For each contract, you have to store a start date, an end date, and the text of the contract. • Pharmacies appoint a supervisor for each contract. Draw an ER diagram using min-max notation that captures the preceding information.
• Patients are identified by an SSN, and their names, addresses, and dob must be recorded. • Doctors are identified by an SSN. For each doctor, the name, specialty, and years of experience must be recorded. • Each pharmaceutical company is identified by name and has a phone number. • 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 a drug uniquely from among the products of that company. • Each pharmacy has a name, address, and phone number. • Every patient has one primary physician. • 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 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. • Pharmaceutical companies have long-term contracts with pharmacies. A pharmaceutical company can contract with several pharmacies, and a pharmacy can contract with several pharmaceutical companies. For each contract, you have to store a start date, an end date, and the text of the contract. • Pharmacies appoint a supervisor for each contract. Draw an ER diagram using min-max notation that captures the preceding information.
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Big Data
Section: Chapter Questions
Problem 7SAT
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning