Map the E-E-R schema for the partial RevisedEmployee database below into a relational schema.

ITC 341 Fall 2018 Quiz 3 Instructor: Dr. Ugur
Name:______________________________ Date: 10/18/2018 (Total 20 points, take home, open book & notes)
1
Type your answers in a Word document called quiz3.docx, put your full name on the top, and submit the file on Blackboard.
Map the E-E-R schema for the partial RevisedEmployee database below into a relational schema. Specify all primary keys and foreign keys. Please state any assumptions you make. Use the convention shown for the example below:
/* p-key means primary key, fr-key means foreign key */
EMP (ssn, ename, bdate, dno, salary, superid)
p-key (ssn),
fr-key (dno) references DEPT(dno), /* here (DEPT is another table whose key is dno) */
fr-key (superid) references EMP(ssn).
FIGURE 4.1. An EER diagram notation to represent subclasses and specialization.
primary-key for PROJECT is pid, for TRADE_UNION is uid.
MANAGES is 1-to-Many (1 on MANAGER link, M on PROJECT link)
BELONGS_TO is 1-to-1
Salaried_employee and Hourly_employee are disjoint (d).