All Many to Many Relationships should have two ER diagrams. If you are not sure what they are, check the sample answers posted as the first item in this Assignment section.

All Foreign keys should be clearly marked - All diagrams should be clearly drawn using draw.io

The number of tables needed should be clearly specified.

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

All questions require an ER diagram in proper notation identifying all properties of the relationship. ER diagrams must be complete in all respects including all cardinality constraints and other specific nature of relationships such as superclass/subclass. All questions require the specification of tables and associated attributes. The entire diagram must be in Microsoft Word (including all diagrams) and the final report submitted as a word document. Also, create the necessary tables in Oracle and submit the SQL statements as part of your word document.

In an apartment complex, a resident can have many pets, but a given pet can have only one resident as its owner. Draw an ER model to represent this relationship. A resident is identified by an apartment number, name, lease begin and lease end dates. A pet has its license number, kind, and its weight.