Question: sharp sharp please Exercise II: Relational Algebra (25 marks) * Student (Sid, Sname, Level, Major) * Course CourseId, Title, DeptId ) * Department (Deptid, DeptName,

sharp sharp please
sharp sharp please Exercise II: Relational Algebra (25 marks) * Student (Sid,

Exercise II: Relational Algebra (25 marks) * Student (Sid, Sname, Level, Major) * Course CourseId, Title, DeptId ) * Department (Deptid, DeptName, Location) * Enroll (Sid, CourseId, Dept Id, EnrDate) * ClubMemebr (Club, headclub_Id, Sid, startDate) Note that, Student. Major-Department. Dept Name and club.headClub.Id-student. Sid Express the following English queries in Relation algebra expression 1. Find name of students who who've register for the French club (5 marks) 2. Find student who is heading the Book club25 marks) 3. Find IDs and Name of students in 400 levels that have enrolled a course that belong to the computer science (CS) department (5 marks) 4. Draw the tree expression of the result gotten in the question (3) (5 marks) 5. Find the club that Usman (student) from computer science (CS) belongs to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!