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.
The post Create a complete ERD with entities and relationships appeared first on My Assignment Online.
Plagiarism Free Assignment Help
Expert Help With This Assignment — On Your Terms
✓ Native UK, USA & Australia writers
✓ Deadline from 3 hours
✓ 100% Plagiarism-Free — Turnitin included
✓ Unlimited free revisions
✓ Free to submit — compare quotes