Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part 2 Lnai 8725

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448505, 978-3662448502

More Books

Students also viewed these Databases questions

Question

Question Can any type of stock or securities be used in an ESOP?

Answered: 1 week ago

Question

Question Can a self-employed person adopt a money purchase plan?

Answered: 1 week ago