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 specification of tables and associated attributes.

Also, create the necessary tables in Oracle and submit the SQL statements

4. Traveling employees in an office are assigned cars. Some cars are assigned to 50 employees which is the maximum number that can use that car. An employee can be assigned to a maximum of 10 cars. All employees must be assigned to a car and a car must be assigned to an employee. Cars have registration number, make, model, year purchased and purchase price. Employees have employee number and other normal employee attributes.

All many to many relationships should have two ER diagrams.

All Foreign keys should be clearly marked

All diagrams should be clearly drawn.

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.