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 Do not create the database or write SQL appeared first on My Assignment Online.