Given the above description, draw an ER diagram for the database. State any assumptions you make for your ER-diagram to support your design. Include the following into your design:
- all the entity sets
- all the attributes
- all the relationship sets using the Crow's Foot Model
- Make sure that all M:M relationships have been converted using associative tables
- Identify the entire primary key for each entity.
Identify all the foreign keys if needed.