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 PRIMARY KEY,
Name VARCHAR
Address VARCHAR
Telephone CHAR
Sex CHAR
Title VARCHAR
Salary DECIMAL
Degrees VARCHAR
;
CREATE TABLE Student
CampusWideID CHAR PRIMARY KEY,
FirstName VARCHAR
LastName VARCHAR
Address VARCHAR
Telephone CHAR
MajorDepartment INT,
FOREIGN KEY MajorDepartment REFERENCES DepartmentDepartmentNumber
;
CREATE TABLE Department
DepartmentNumber INT PRIMARY KEY,
Name VARCHAR
Telephone CHAR
OfficeLocation VARCHAR
Chairperson CHAR
FOREIGN KEY Chairperson REFERENCES ProfessorSSN
;
CREATE TABLE Course
CourseNumber INT PRIMARY KEY,
Title VARCHAR
Textbook VARCHAR
Units INT,
DepartmentNumber INT,
Prerequisite INT,
FOREIGN KEY DepartmentNumber REFERENCES DepartmentDepartmentNumber
FOREIGN KEY Prerequisite REFERENCES CourseCourseNumber
;
CREATE TABLE Section
CourseNumber INT,
SectionNumber INT,
Classroom VARCHAR
Seats INT,
MeetingDays VARCHAR
StartTime TIME,
EndTime TIME,
TaughtBy CHAR
PRIMARY KEY CourseNumber SectionNumber
FOREIGN KEY CourseNumber REFERENCES CourseCourseNumber
FOREIGN KEY TaughtBy REFERENCES ProfessorSSN
;
CREATE TABLE Minor
StudentID CHAR
DepartmentNumber INT,
PRIMARY KEY StudentID DepartmentNumber
FOREIGN KEY StudentID REFERENCES StudentCampusWideID
FOREIGN KEY DepartmentNumber REFERENCES DepartmentDepartmentNumber
;
CREATE TABLE Enrollment
StudentID CHAR
CourseNumber INT,
SectionNumber INT,
Grade CHAR
PRIMARY KEY StudentID CourseNumber, SectionNumber
FOREIGN KEY StudentID REFERENCES StudentCampusWideID
FOREIGN KEY CourseNumber SectionNumber REFERENCES SectionCourseNumber SectionNumber
;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
