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
Expert Solution
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