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

icon
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
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
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer