PROFESSOR Professor ID Department Professor Specialty Professor Rank Professor L
ID: 3711738 • Letter: P
Question
PROFESSOR
Professor ID
Department
Professor Specialty
Professor Rank
Professor Last Name
Professor First Name
Professor Initial
Professor Email
SCHOOL
School ID
School Name
SCHOOLDEAN
School
Dean
DEPARTMENT
Department Code
Department Name
School
DEPARTMENTCHAIR
Department
Chair
STUDENT
Student ID
Department
Student Last Name
Student First Name
Student Initial
Student Email
Advisor
COURSE
Course Code
Department
Course Title
Course Description
Course Credits
CLASS
Class Code
Class Section
Class Time
Course
Professor
Room
ENROLL
Class
Student
Enrollment Date
Enrollment Grade
BUILDIING
Building Name
Building Location
ROOM
Room Code
Room Type
Building
sql code to drop and create table
PROFESSOR
Professor ID
Department
Professor Specialty
Professor Rank
Professor Last Name
Professor First Name
Professor Initial
Professor Email
SCHOOL
School ID
School Name
SCHOOLDEAN
School
Dean
DEPARTMENT
Department Code
Department Name
School
DEPARTMENTCHAIR
Department
Chair
STUDENT
Student ID
Department
Student Last Name
Student First Name
Student Initial
Student Email
Advisor
COURSE
Course Code
Department
Course Title
Course Description
Course Credits
CLASS
Class Code
Class Section
Class Time
Course
Professor
Room
ENROLL
Class
Student
Enrollment Date
Enrollment Grade
BUILDIING
Building Name
Building Location
ROOM
Room Code
Room Type
Building
Explanation / Answer
SQL CODE FOR CREATING TABLE:-
Case 1:PROFESSOR
Code: CREATE TABLE PROFESSOR(Professor_Id int NOT NULL PRIMARY KEY, Department varchar(255), Professor_Speciality varchar(255), Professor_Rank int, Professor_LastName varchar(255), Professor_FirstName varchar(255), Professor_Initial varchar(255), Professor_Email varchar(255) );
Case 2:SCHOOL
Code: CREATE TABLE SCHOOL(School_Id int NOT NULL PRIMARY KEY, School_Name varchar(255));
Case 3: SCHOOLDEAN
Code: CREATE TABLE SCHOOLDEAN(School varchar(255) FOREIGN KEY REFERENCES SCHOOL(School_Id), Dean varchar(255));
Case 4:DEPARTMENT
Code: CREATE TABLE DEPARTMENT(Department_Code varchar(255), Dept_Name varchar(255), School varchar(255) FOREIGN KEY REFERENCES SCHOOL(School_Id));
Case 5:DEPARTMENTCHAIR
Code: CREATE TABLE DEPARTMENTCHAIR(Department varchar(255) PRIMARY KEY, Chair varchar(255));
Case 6:STUDENT
Code: CREATE TABLE STUDENT(Student_ID varchar(255) NOT NULL PRIMARY KEY, Department varchar(255) FOREIGN KEY REFERENCES DEPARTMENTCHAIR(Department), Stud_LastName varchar(255), Stud_FirstName varchar(255), Student_Initial varchar(255), Student_email varchar(255), Advisor varchar(255));
Case 7:COURSE
Code:CREATE TABLE COURSE(Course_code int NOT NULL PRIMARY KEY, Department varchar(255) FOREIGN KEY REFERENCES DEPARTMENTCHAIR(Department), Course_title varchar(255), Course_Desc varchar(255), Course_credits varchar(255));
Case 8:CLASS
Code:CREATE TABLE CLASS(Class_code varchar(255) NOT NULL PRIMARY KEY, Class_Section varchar(5), Class_time varchar(255), Course varchar(255) FOREIGN KEY REFERENCES COURSE(Course_code), Professor varchar(255) FOREIGN KEY REFERENCES PROFESSOR(Professor_Id), Room varchar(255) FOREIGN KEY REFERENCES ROOM(Room_code));
Case 9:ENROLL
Code:CREATE TABLE ENROLL(Class varchar(255) FOREIGN KEY REFERENCES CLASS(Class_code), Student varchar(255) FOREIGN KEY REFERENCES STUDENT(Student_ID), Enrollment_date varchar(255), Enrollment_Grade varchar(10));
Case 10:BUILDING
Code:CREATE TABLE BUILDING(Building_Name varchar(255) NOT NULL PRIMARY KEY, Building_Location varchar(255));
Case 11:ROOM
Code:CREATE TABLE ROOM(Room_code varchar(255) NOT NULL PRIMARY KEY, Room_Type varchar(255), Building varchar(255) FOREIGN KEY REFERENCES BUILDING(Building_Name));
SQL CODE FOR DROPPING THE TABLE:
Case 1: DROP TABLE PROFESSOR;
Case 2: DROP TABLE SCHOOL;
Case 3: DROP TABLE SCHOOLDEAN;
Case 4: DROP TABLE DEPARTMENT;
Case 5: DROP TABLE DEPARTMENTCHAIR;
Case 6: DROP TABLE STUDENT;
Case 7: DROP TABLE COURSE;
Case 8: DROP TABLE CLASS;
Case 9: DROP TABLE ENROLL;
Case 10: DROP TABLE BUILDING;
Case 11: DROP TABLE ROOM;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.