Question: Write SQL queries based on the following database Schema: classroom(building, room_number, capacity) department( dept_name , building, budget) course(course_id, title, dept_name, credits) instructor(ID, name, dept_name, salary)

Write SQL queries based on the following database 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, i_ID)

time_slot(time_slot_id, day, start_time, end_time)

prereq(course_id, prereq_id)

  1. Find the number of students in each section that was offered in Fall 2009.

  1. Find the maximum enrollment, across all sections, in Fall 2009. (use a subquery in FROM clause, will be covered soon)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!