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, 

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

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 Algorithms Questions!