-
Derive relational schema from your ER model thatrepresents the entities and relationships. Identify primary,alternate and foreign keys. Note: use the following notation todescribe your relational schema, as shown in the example of a Staffrelation given below.
Staff (staffNo, fName, lName, address, NIN,sex, DOB, deptNo) Primary Key staffNo
Alternate Key lName, DOB
Alternate Key NIN
Foreign Key deptNo references Department(deptNo) On Delete NoAction On Update Cascade

I Module Course course_code INT course tite VARCHAR(45) years INT ◆ Academ ic-staff-Staff num ber TNT courses
PayPal Gateway not configured
PayPal Gateway not configured