Relational Algebra Consider The Schema Below Student Studentid Name Address Email Dob Faculty Project Code Title 1 (97.94 KiB) Viewed 26 times
Relational Algebra Consider The Schema Below Student Studentid Name Address Email Dob Faculty Project Code Title 2 (10.63 KiB) Viewed 26 times
RELATIONAL ALGEBRA Consider the schema below: Student(studentID, name, address, email, dob, Faculty) Project(Code, title, credit, TRN) Foreign Key TRN references Lecturer Undertakes(studentID, Code, TRN, grade, yearTaken) Foreign Key TRN references Lecturer Foreign Key Code references Project Foreign Key studentID references Student Lecturer(TRN, name, gender, researchArea, Faculty) VIII.
Using the following symbols copy as required (copy and paste), write expressions in relational algebra to: (0,1,, X, , N, KECU, n,) a) Show the names of the students who have undertaken a project supervised by Denise Allen and have received an A. [2 marks] b) Show all the students who have not undertaken any projects [2 marks] c) Show the names of all students who had to redo their project i.e. they undertook more than one project [3 marks] d) Show the lecturers' name, TRN and researchArea for all lecturers who supervised a project by a student that is not in the same faculty as them [2 marks]
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!