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 as part of your word document.

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.

3) All computers at NKU have tags, a unique number assigned at the time of purchase. In addition they have purchase date, manufacturer, and an operating system version. Some computers are servers which have (in addition to the above columns) a static IP address and also a server administrator, who is the person responsible for that computer. The computers that are non servers are called workstations. They are either in a lab or in faculty or staff offices which are simply designated room number.