Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

XML Data Management Native XML And XML Enabled Database Systems

Authors: Akmal Chaudhri, Awais Rashid, Roberto Zicari, John Fuller

1st Edition

0201844524, 978-0201844528

More Books

Students also viewed these Databases questions