Design the ER diagram using what you have learned in

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.

Expert Help With This Assignment — On Your Terms