Question: Study the following associations: Student(reg_num: integer, student_name: string, course: string, year: string, age: integer) Group(name: string, time: string, room: string, fac_id: integer) Admitted(reg_num: integer,
Study the following associations: Student(reg_num: integer, student_name: string, course: string, year: string, age: integer) Group(name: string, time: string, room: string, fac_id: integer) Admitted(reg_num: integer, cname: string) Faculty(fac_id: integer, fac_name: string, dept_id: integer) 2.1 Determine the names of staff (faculty members) whose total registered students in the courses they teach is fewer than five. (5 Marks) 2.2 Print the names of staff who have only used room H275 for lectures, as well as the total number of groups that each one of them has taught. (5 Marks) (5 Marks) [Sub Total 15 Markel 2.3 Determine the names of registered students in the highest number of groups.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
