Answer Happy

Posted: **Fri Jul 08, 2022 6:43 am**

: Section 04 10 Points Consider The Following Schema Classroom Building Room Number Capacity Department Dept Name Bui 1 (318.05 KiB) Viewed 33 times

: Section 04 10 Points Consider The Following Schema Classroom Building Room Number Capacity Department Dept Name Bui 2 (228.14 KiB) Viewed 33 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, iJD) time_slot(time_slot id, day, start_time, end_time) prereq(course id, prereq_id)
write a SQL function that takes nothing as parameter but returns number of records in cross join between instructor and department tables. (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. to points [4 points]