For each of these scenarios, draw an ER model, clearly denoting maximum and minimum cardinality constraints.

Write the one liner and four sentences for each diagram (statements that specify the minimum and maximum cardinality), and the number of tables needed.

Post the Primary and foreign keys and any available attributes.

Your diagram must be complete in all respects with all notations .

All many to many relationships should have two ER diagrams.

All Foreign keys should be clearly marked

- All diagrams should be clearly drawn.

All ER diagrams (except superclass/subclass) should have four accompanying statements of maximum and minimum cardinality.

All superclass/subclass diagrams should have an explanatory paragraph on why it is considered Mandatory/optional - And/Or.. This should be clearly labeled in the diagram.

1 ) A class is taught by one faculty, but a faculty can teach many classes. A faculty need not teach any classes but class must be taught by a faculty. A faculty has faculty id, name, address, and department. A class has an ID, name, location, meeting time, and a textbook.