Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write SQ L queries for questions 1-10 using the following University schema. Classroom(building, room_number, capacity) Department(dept name, building, budget) Course course_id title, dept_name, credits) Instructor(i_id
Write SQ L queries for questions 1-10 using the following University schema. Classroom(building, room_number, capacity) Department(dept name, building, budget) Course course_id title, dept_name, credits) Instructor(i_id name, dept name, salary) Section(course_id sec id semester, year, building, room number, time_slot id) Teaches(i_id course_id sec _id semester, year) Students_id, name, dept name, tot_cred) Takes (s_id, course id sec id semester, year grade) Advisor(s id i _id) Time_slottime_slot_id day, start hr, start min, end_hr, end_min) Prereq(course_id prereq_id) Grade_points(grade, points) 4. (10 pts) Find the sections that had the maximum enrollment in the Fall of 2009. There could be more than one course section which has the maximum enrollment.) Output columns: Course id, sec id Sort by: Course id in ascending order Course id sec id
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started