Study the following associations: Student(reg_num: integer, student_name: string, course: string, year: string, age: integer) Group(name: string,...

 

Transcribed Image Text:

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. 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.