Consider the following schema: Student (snum, sname, major, level, dob) Class(cname, meets_at_time, room, fid) Enrolled (snum,...

 

Transcribed Image Text:

Consider the following schema: Student (snum, sname, major, level, dob) Class(cname, meets_at_time, room, fid) Enrolled (snum, cname) Faculty (fid, fname, deptid) Write the following queries using relational algebra. Find the names of students enrolled for the class 'Database Design'. Find the names of all classes that either meet in room '100' or have 5 or more students enrolled. i) ii) iii) Find the names of students enrolled for all classes. iv) Find the names students enrolled in maximum number of classes. v) Find the faculty not assigned to any classes. Consider the following schema: Student (snum, sname, major, level, dob) Class(cname, meets_at_time, room, fid) Enrolled (snum, cname) Faculty (fid, fname, deptid) Write the following queries using relational algebra. Find the names of students enrolled for the class 'Database Design'. Find the names of all classes that either meet in room '100' or have 5 or more students enrolled. i) ii) iii) Find the names of students enrolled for all classes. iv) Find the names students enrolled in maximum number of classes. v) Find the faculty not assigned to any classes.

Answer rating: 100% (QA)

i sname cnameDatabase Design Student Enrolled Explanation Join the Student and Enrolled tables on th... View the full answer