Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create table course ( course _ id varchar ( 8 ) , title varchar ( 5 0 ) , dept _ name varchar ( 2
create table course
courseid varchar
title varchar
deptname varchar
credits numeric check credits
primary key courseid
constraint course foreign key deptname references departmentdeptname
on delete set null
;
create table instructor
ID varchar
name varchar not null,
deptname varchar
salary numeric check salary
primary key ID
constraint instructor foreign key deptname references departmentdeptname
on delete set null
;
create table section
courseid varchar
secid varchar
semester varchar
check semester in Fall 'Winter', 'Spring', 'Summer'
year numeric check year and year
building varchar
roomnumber varchar
timeslotid varchar
primary key courseid secid semester, year
constraint section foreign key courseid references coursecourseid
on delete cascade,
constraint section foreign key building roomnumber
references classroombuilding roomnumber
on delete set null
;
Referring to and tables. Code an SQL statement that,
Gives the course ID section, title, semester, building, and room for courses offered in Fall Order the result by course ID and then section.
Copy
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