Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality constraints, weak entities (if any), and participation constraints. There might be extra constraints which cannot be captured by the E/R diagram, make sure you mention them below the diagram. List any assumptions you make in the process. At a minimum, you will find there are at least seven entities.
For each entity set and relationship, write a concise description describing all model components. One or two sentences per entity set and relationship is enough. Make sure these are in PROPER English and follow technical best-practice guidelines.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
