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 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: Draw extended or normal entity-relationship diagram which satisfies the above requirements
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
