- Section 04 10 Points Consider The Following Schema Classroom Building Room Number Capacity Department Dept Name Bu 1 (35.18 KiB) Viewed 39 times
- Section 04 10 Points Consider The Following Schema Classroom Building Room Number Capacity Department Dept Name Bu 2 (18.2 KiB) Viewed 39 times
Section 04: 10 Points. Consider the following schema classroom(building, room_number, capacity) department(dept_name, building, budget) course(course id, title, dept_name, credits) instructor(ID, name, dept_name, salary) section (course_id, sec_id, semester, year, building, room_number, time_slot_id) teaches(ID, course_id, sec_id, semester, year) student (ID, name, dept_name, tot_cred) takes(ID, course_id, sec_id, semester, year, grade) advisor(s ID, iID) time_slot(time_slot_id, day, start_time, end_time) prereq(course_id, prerequid) Page (1) write a SQL function that takes nothing as parameter but returns number of records in cross join between instructor and department tables. [6 points] A of 5
(ii) Considering above schema, create a view which will allow corresponding users to see only name of the department with total salary of instructors of corresponding department. [4 points]