Question
Given the following requirements for pharmaceutical company, drug, pharmacy, patient, and doctor, Each pharmaceutical company has a unique name c_name and multiple phones c_phones, and
Given the following requirements for pharmaceutical company, drug, pharmacy, patient, and doctor, Each pharmaceutical company has a unique name c_name and multiple phones c_phones, and may manufacture some drugs. Each pharmaceutical company also has an attribute total_drugs (derived from the number of drugs manufactured by the company). Each drug has a name d_name, and is manufactured by exactly one pharmaceutical company. Drugs made by different pharmaceutical companies may have duplicated d_names. Drugs made by each pharmaceutical company has unique d_name. Each drug may be sold by some pharmacies. Each drug may be bought by some patients. Each pharmacy has a unique name p_name, and a unique address p_addr. It sells one or more drugs, each with a price d_price (drug-dependent and pharmacy-dependent). Each pharmacy may be shopped by some patients. Each doctor has a unique id NPI and a name doc_name. Each doctor is the primary doctor of at least 3 up to 35 patients. A doctor may be office-visited by some patients (primary or not). Each patient has a name p_name and a unique SSN, and has exactly one primary doctor. A patient may officevisit some doctors (primary or not). Each office-visit has a date v_date (patient-dependent and doctordependent). A patient may buy some drugs, each of which with quantity d_qty and date p_date (both d_qty and p_date are patient-dependent and drug-dependent). Each patient may shop at some pharmacies.
Please help me with the er diagram of peter chenns model of this..
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started