[Solved] C Prorile Coristraf 2 20 Points Schema University Database Answer Questions 1 10 Classroom Q37276766
C. prorile a.CoriStraf 2. (20 points) From the schema of the university database, answer questions 1)-10) 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, see id, semester, year, grade) ADVISOR (s ID, i ID) TIME_SLOT (time slot id, day, start time, end_time) PREREQ (course id, prerea id) 1) Find the titles of courses in the Computer Science department that have 3 credits. 2) Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. 3) Find the highest salary of any instructor 4) Find all instructors earning the highest salary (there may be more than one with the same salary) 5) Find the enrollment of each section that was offered in Fall 2017 6) Find the maximum enrollment, across all sections, in Fall 2017. 7) Find the sections that had the maximum enrollment in Fall 2017. 8) Increase the salary of each instructor in the Comp. Sci. department by 10%. 9) Delete all courses that have never been offered (that is, do not occur in the section relation) 10) Insert every student whose tot_cred attribute is greater than 100 as an instructor in the same department, with a salary of $10,000 Show transcribed image text C. prorile a.CoriStraf 2. (20 points) From the schema of the university database, answer questions 1)-10) 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, see id, semester, year, grade) ADVISOR (s ID, i ID) TIME_SLOT (time slot id, day, start time, end_time) PREREQ (course id, prerea id) 1) Find the titles of courses in the Computer Science department that have 3 credits. 2) Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. 3) Find the highest salary of any instructor 4) Find all instructors earning the highest salary (there may be more than one with the same salary) 5) Find the enrollment of each section that was offered in Fall 2017 6) Find the maximum enrollment, across all sections, in Fall 2017. 7) Find the sections that had the maximum enrollment in Fall 2017. 8) Increase the salary of each instructor in the Comp. Sci. department by 10%. 9) Delete all courses that have never been offered (that is, do not occur in the section relation) 10) Insert every student whose tot_cred attribute is greater than 100 as an instructor in the same department, with a salary of $10,000
Expert Answer
Answer to C. prorile a.CoriStraf 2. (20 points) From the schema of the university database, answer questions 1)-10) CLASSROOM (bui… . . .
OR
