Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw extended or normal entity-relationship diagram Q2. Assume you have been asked to develop a database conceptual model for the covid-19. You have been given
Draw extended or normal entity-relationship diagram
Q2. Assume you have been asked to develop a database conceptual model for the covid-19. You have been given the freedom to come up with your own design but with the following restrictions. 1. You must have at least five entities which may include things like country, virus, patients, hospitals, drugs, vaccines, pharmacological companies, etc. 2. Each entity should have at least three attributes, including a primary key which should be underlined. 3. You should have reasonable relationships between the entities with a. at least one recursive (self-referencing) relationship, b. at least one relationship which connects more than two entities, and c. at least two binary relationships. d. at least one of the relationships should have at least one attribute. e. specify the cardinality of each relationship with at least one many-to-many relationship Solve the following: a. Draw your own extended or normal entity-relationship diagram which satisfies the above requirements. Your design should be sound and reflects a practical case. b. Transform your ERD or EERD into a relational model, you may or may not use arrows
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