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.

2) In a faculty office of a department, each faculty has separate printer assigned to her which is connected to her computer. A printer cannot be assigned to more than one faculty and a faculty cannot have more than one printer. The printer has a printer id, model name, date from and date to, and the faculty has faculty id, department, and date joined columns. A faculty must have a printer but a printer need not be assigned to a faculty.