Draw a Model Entity Relationship diagram with the following data. Entity Person Forecast Recipe Medical Pharmaceutical company Pharmacy Medication Contract Phone Specialty Relationship Patient - Doctor Patient - Doctor - Prescription Medical - Specialty Patient - Forecast pharmaceutical company - medicine Recipe - Medication Pharmacy - Medicine pharmaceutical company - pharmacy - supervisor - contract Key DNI Code Code Code Code Name Code Code Code Relationship Attribute Start date and End date Broadcast date amount price Attributes Name, Address, City, Phone, Name, type Text, date Name, telephone Name, address, phone Formula Start date, End date, text Name Order Cardinality Medical N to 1 patient NaN NaN 1 patient-n forecast NaN NaN NaN Correct Primary Correct NaN Cardinality 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Correspondence 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Description MER Explanation 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Draw a Model Entity Relationship diagram with the following data. Entity Person Forecast Recipe Medical Pharmaceutical company Pharmacy Medication Contract Phone Specialty Relationship Patient - Doctor Patient - Doctor - Prescription Medical - Specialty Patient - Forecast pharmaceutical company - medicine Recipe - Medication Pharmacy - Medicine pharmaceutical company - pharmacy - supervisor - contract Key DNI Code Code Code Code Name Code Code Code Relationship Attribute Start date and End date Broadcast date amount price Attributes Name, Address, City, Phone, Name, type Text, date Name, telephone Name, address, phone Formula Start date, End date, text Name Order Cardinality Medical N to 1 patient NaN NaN 1 patient-n forecast NaN NaN NaN Correct Primary Correct NaN Cardinality 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Correspondence 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Description MER Explanation 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Related questions
Question
![Draw a Model Entity Relationship diagram with the following data.
Entity
Person
Forecast
Recipe Medical
Pharmaceutical company
Pharmacy
Medication
Contract
Phone
Specialty
Relationship
Patient - Doctor
Patient - Doctor - Prescription
Medical - Specialty
Patient - Forecast
pharmaceutical company - medicine
Recipe - Medication
Pharmacy - Medicine
pharmaceutical company - pharmacy -
supervisor - contract
Key
DNI
Code
Code
Code
Code
Name
Code
Code
Code
Relationship Attribute
Start date and End date
Broadcast date
amount
price
Attributes
Name, Address, City, Phone,
Name, type
Text, date
Name, telephone
Name, address, phone
Formula
Start date, End date, text
Name
Order Cardinality
Medical N to 1 patient
NaN
NaN
1 patient - n forecast
NaN
NaN
NaN
Correct Primary Correct
NaN
Cardinality
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Correspondence
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Description MER
Explanation
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F07a872f1-2c21-4885-b59a-a10baef94f30%2F838a5a4a-cce6-40e0-aebc-721abdf7c302%2Fncssxfu_processed.png&w=3840&q=75)
Transcribed Image Text:Draw a Model Entity Relationship diagram with the following data.
Entity
Person
Forecast
Recipe Medical
Pharmaceutical company
Pharmacy
Medication
Contract
Phone
Specialty
Relationship
Patient - Doctor
Patient - Doctor - Prescription
Medical - Specialty
Patient - Forecast
pharmaceutical company - medicine
Recipe - Medication
Pharmacy - Medicine
pharmaceutical company - pharmacy -
supervisor - contract
Key
DNI
Code
Code
Code
Code
Name
Code
Code
Code
Relationship Attribute
Start date and End date
Broadcast date
amount
price
Attributes
Name, Address, City, Phone,
Name, type
Text, date
Name, telephone
Name, address, phone
Formula
Start date, End date, text
Name
Order Cardinality
Medical N to 1 patient
NaN
NaN
1 patient - n forecast
NaN
NaN
NaN
Correct Primary Correct
NaN
Cardinality
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Correspondence
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Description MER
Explanation
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)