Create a complete ERD with entities and relationships using given scenario….

a. Create a complete ERD with entities and relationships using given scenario.

Make sure that relationship types, participation and cardinality is shown in

ERD.

b. Convert the ERD to a set of relational tables in at least 3NF and draw a

dependency diagram

c. Create a database using MICROSOFT ACCESS- with primary keys, foreign keys,

and other attributes mentioned for each entity using proper constraints.

d. Create a form to input/update data

e. Input some significant data in each table showing your understanding of the

scenario.

f. Create three queries.

g. Create a report.

Attachments: