Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Integration Services

Authors: Brian Knight, Devin Knight

1st Edition

1118850904, 9781118850909

More Books

Students also viewed these Databases questions

Question

What should Meddevco have done to avoid some of its problems?

Answered: 1 week ago