Introduction to Database Design 13 Exercise 2.7 The Prescriptions-R-X chain of pharmacies has oFered to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here’s the information that you gather: Patients are identi±ed by an SSN, and their names, addresses, and ages must be recorded. Doctors are identi±ed by an SSN. ²or each doctor, the name, specialty, and years of experience must be recorded. Each pharmaceutical company is identi±ed by name and has a phone number. ²or each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identi±es a drug uniquely from among the products of that company. If a pharmaceutical company is deleted, you need not keep track of its products any longer. Each pharmacy has a name, address, and phone number. Every patient has a primary physician. Every doctor has at least one patient. 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.

This
preview
has intentionally blurred sections.
Sign up to view the full version.