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 .

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.

5) Courses have prerequisites. Courses need not have prerequisites. One course can have many prerequisites. Many courses may have the same prerequisite.