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