Question: 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

 Q2. Assume you have been asked to develop a database conceptual

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!