All Many to Many Relationships should have two ER diagrams.

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. Also, create the necessary tables in Oracle and submit the SQL statements as part of your word document.

3) AIRJET is a company that leases out private planes to various company executives. And it has a set of pilots on its list. Each pilot can fly at most ten planes, and a plane can have an unlimited number of pilots eligible to fly. Draw this relationship between planes and pilots. A plane has a model number, the number of hours flown, and the date it was installed in service and the next service date. A pilot has a flying license number, hours flown, and the license expiration date. Decide on the number of tables and include appropriate columns in the respective tables.