Design the ER diagram using what you have learned in the video lecture series we watched. Do not create the database or write SQL. This is a schema design exercise. Links to the applicable videos are below for your reference.
- ER Diagram Intro – https://www.mikedane.com/databases/sql/er-diagrams-intro/
- Designing an ER Diagram – https://www.mikedane.com/databases/sql/designing-an-er-diagram/
Make sure to use the same symbols and notation that Mike Dane uses in his videos. In particular, make sure to identify the following:
- All tables of the library database.
- All attributes of each table.
- The primary key of each table.
- Relationships between tables.
- Cardinality of relationships (1:1, 1:N, N:M)
You may use whatever method you are comfortable with in constructing the ER Diagram
The post Design the ER diagram using what you have learned in 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