The Prescriptions-R-X chain of pharmacies has oered 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 identied by an SSN, and their names, addresses, and ages must be recorded. Doctors

are identied by an SSN. For each doctor, the name, specialty, and years of experience must be

recorded. Each pharmaceutical company is identied 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 identies 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. 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. You can assume that, if a doctor prescribes the same drug for the same patient

more than once, only the last such prescription needs to be stored. 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 must store a start date, an end date, and the text of the contract. Pharmacies appoint a

supervisor for each contract. There must always be a supervisor for each contract, but the contract

supervisor can change over the lifetime of the contract.

Question

1. Draw an ER diagram that captures the preceding information.

ct Question 7 0 / 2 pts Use the following Total Tax / Annual Income relationship to determine which of the following would be used to calculated the Total Tax for an Annual Income of $58,900? Annual Income x $0. 10. 1f 50 5 Annual Income $ $9.525 $952. 50 + (Annual Income - 9,525) x 50.12, if $9,525