Answered step by step
Verified Expert Solution
Question
1 Approved Answer
using the above schema solve the following queries 1) Create a section of this course in Fall 2009, with section id of 1. 2) Enroll
using the above schema solve the following queries
1) Create a section of this course in Fall 2009, with section id of 1.
2) Enroll every student in the Comp. Sci. department in the above section.
3) Delete enrollments in the above section where the students name is Chavez.
4) Delete the course CS-001.
5) Delete all takes tuples corresponding to any section of any course with the word database as a part of the title; ignore case when matching the word with the title.
classroom(building, room number, capacity) department dept-name, building, budget) courselcourse id, title, deptname, credits) instructor(ID, name, dept.name, salary) section(course id, sec id, semester, year, building, roomumber, time slotid) teaches(ID, course id, sec id, semester, year) student ID, name, dept name, tot cred) takes(ID, course.id, secid, semester year, grade) advisor(S-ID, JD) time slot(time-slot.id, day, start time, endtime) prereq course id, prereqid)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