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

See similar textbooks

Related questions

Concept explainers

Question

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

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions