Question: Can you DRAW OUT a Relational Model from the sql provided below? CREATE TABLE Professor ( SSN CHAR ( 9 ) PRIMARY KEY, Name VARCHAR
Can you DRAW OUT a Relational Model from the sql provided below?
CREATE TABLE Professor
SSN CHARPRIMARY KEY,
Name VARCHAR
Address VARCHAR
Telephone CHAR
Sex CHAR
Title VARCHAR
Salary DECIMAL
Degrees VARCHAR
;
CREATE TABLE Student
CampusWideID CHARPRIMARY KEY,
FirstName VARCHAR
LastName VARCHAR
Address VARCHAR
Telephone CHAR
MajorDepartment INT,
FOREIGN KEY MajorDepartmentREFERENCES DepartmentDepartmentNumber
;
CREATE TABLE Department
DepartmentNumber INT PRIMARY KEY,
Name VARCHAR
Telephone CHAR
OfficeLocation VARCHAR
Chairperson CHAR
FOREIGN KEY ChairpersonREFERENCES ProfessorSSN
;
CREATE TABLE Course
CourseNumber INT PRIMARY KEY,
Title VARCHAR
Textbook VARCHAR
Units INT,
DepartmentNumber INT,
Prerequisite INT,
FOREIGN KEY DepartmentNumberREFERENCES DepartmentDepartmentNumber
FOREIGN KEY PrerequisiteREFERENCES CourseCourseNumber
;
CREATE TABLE Section
CourseNumber INT,
SectionNumber INT,
Classroom VARCHAR
Seats INT,
MeetingDays VARCHAR
StartTime TIME,
EndTime TIME,
TaughtBy CHAR
PRIMARY KEY CourseNumberSectionNumber
FOREIGN KEY CourseNumberREFERENCES CourseCourseNumber
FOREIGN KEY TaughtByREFERENCES ProfessorSSN
;
CREATE TABLE Minor
StudentID CHAR
DepartmentNumber INT,
PRIMARY KEY StudentIDDepartmentNumber
FOREIGN KEY StudentIDREFERENCES StudentCampusWideID
FOREIGN KEY DepartmentNumberREFERENCES DepartmentDepartmentNumber
;
CREATE TABLE Enrollment
StudentID CHAR
CourseNumber INT,
SectionNumber INT,
Grade CHAR
PRIMARY KEY StudentIDCourseNumber SectionNumber
FOREIGN KEY StudentIDREFERENCES StudentCampusWideID
FOREIGN KEY CourseNumberSectionNumberREFERENCES SectionCourseNumberSectionNumber
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
