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. The entire diagram must be on 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. 1. 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. 2. Courses have prerequisites. Courses need not have prerequisites. One course can have many prerequisites. Many courses may have the same prerequisite.