FACULTY (Faculty Code, Faculty Name) DEPARTMENT (Dept_ID, Dept_Name, Faculty_Code*) LECTURER (Lect_ID, Lect_Name, Lect_Qualification, Dept_ID*) FULL TIME LECTURER (Lect ID*, Expertise, HireDate) PART...


FACULTY (Faculty Code, Faculty Name)<br>DEPARTMENT (Dept_ID, Dept_Name, Faculty_Code*)<br>LECTURER (Lect_ID, Lect_Name, Lect_Qualification, Dept_ID*)<br>FULL TIME LECTURER (Lect ID*, Expertise, HireDate)<br>PART TIME LECTURER (Lect ID*,<br>HoursWork, RatePerHour)<br>a)<br>Based on the above relational schema you are required to draw the Entity Relationship<br>Diagram (ERD).<br>b)<br>Do the relational schema above exhibits referential integrity? Answer yes or no and then<br>explain your answer.<br>TABLE<br>REFERENTIAL<br>INTEGRITY<br>EXPLANATION<br>FACULTY<br>DEPARTMENT<br>LECTURER<br>FULL_TIME_LECTURER<br>PART_TIME_LECTURER<br>

Extracted text: FACULTY (Faculty Code, Faculty Name) DEPARTMENT (Dept_ID, Dept_Name, Faculty_Code*) LECTURER (Lect_ID, Lect_Name, Lect_Qualification, Dept_ID*) FULL TIME LECTURER (Lect ID*, Expertise, HireDate) PART TIME LECTURER (Lect ID*, HoursWork, RatePerHour) a) Based on the above relational schema you are required to draw the Entity Relationship Diagram (ERD). b) Do the relational schema above exhibits referential integrity? Answer yes or no and then explain your answer. TABLE REFERENTIAL INTEGRITY EXPLANATION FACULTY DEPARTMENT LECTURER FULL_TIME_LECTURER PART_TIME_LECTURER

Jun 07, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?