Question: Can you create a Relational Model from the sql provided below? CREATE TABLE Professor ( SSN CHAR ( 9 ) PRIMARY KEY, Name VARCHAR (

Can you create a Relational Model from the sql provided below?
CREATE TABLE Professor (
SSN CHAR(9) PRIMARY KEY,
Name VARCHAR(100),
Address VARCHAR(200),
Telephone CHAR(10),
Sex CHAR(1),
Title VARCHAR(50),
Salary DECIMAL(10,2),
Degrees VARCHAR(200)
);
CREATE TABLE Student (
CampusWideID CHAR(9) PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Address VARCHAR(200),
Telephone CHAR(10),
MajorDepartment INT,
FOREIGN KEY (MajorDepartment) REFERENCES Department(DepartmentNumber)
);
CREATE TABLE Department (
DepartmentNumber INT PRIMARY KEY,
Name VARCHAR(100),
Telephone CHAR(10),
OfficeLocation VARCHAR(100),
Chairperson CHAR(9),
FOREIGN KEY (Chairperson) REFERENCES Professor(SSN)
);
CREATE TABLE Course (
CourseNumber INT PRIMARY KEY,
Title VARCHAR(100),
Textbook VARCHAR(200),
Units INT,
DepartmentNumber INT,
Prerequisite INT,
FOREIGN KEY (DepartmentNumber) REFERENCES Department(DepartmentNumber),
FOREIGN KEY (Prerequisite) REFERENCES Course(CourseNumber)
);
CREATE TABLE Section (
CourseNumber INT,
SectionNumber INT,
Classroom VARCHAR(50),
Seats INT,
MeetingDays VARCHAR(50),
StartTime TIME,
EndTime TIME,
TaughtBy CHAR(9),
PRIMARY KEY (CourseNumber, SectionNumber),
FOREIGN KEY (CourseNumber) REFERENCES Course(CourseNumber),
FOREIGN KEY (TaughtBy) REFERENCES Professor(SSN)
);
CREATE TABLE Minor (
StudentID CHAR(9),
DepartmentNumber INT,
PRIMARY KEY (StudentID, DepartmentNumber),
FOREIGN KEY (StudentID) REFERENCES Student(CampusWideID),
FOREIGN KEY (DepartmentNumber) REFERENCES Department(DepartmentNumber)
);
CREATE TABLE Enrollment (
StudentID CHAR(9),
CourseNumber INT,
SectionNumber INT,
Grade CHAR(2),
PRIMARY KEY (StudentID, CourseNumber, SectionNumber),
FOREIGN KEY (StudentID) REFERENCES Student(CampusWideID),
FOREIGN KEY (CourseNumber, SectionNumber) REFERENCES Section(CourseNumber, SectionNumber)
);

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 Programming Questions!