SCHOOL-BUILD, Sql Server

SCHOOL-BUILD

CREATE TABLE Student (
StudentID INT NOT NULL,
GraduationDate DATE NOT NULL,
CONSTRAINT Student_PK PRIMARY KEY (StudentID));

CREATE TABLE Enrollment (
ClassID INT NOT NULL,
StudentID INT NOT NULL,
EnrolledDate DATE NOT NULL,
Grade VARCHAR(2));

CREATE TABLE Classes (
ClassID INT NOT NULL,
CourseID INT NOT NULL,
InstructorID INT NOT NULL,
RoomID INT NOT NULL,
DayofWeek DATETIME NOT NULL,
StartTime DATETIME NOT NULL,
CONSTRAINT Classes_PK PRIMARY KEY (ClassID));

CREATE TABLE Course (
CourseID INT NOT NULL,
CourseDesc VARCHAR(256)
CONSTRAINT Course_PK PRIMARY KEY (CourseID));

CREATE TABLE Room (
RoomID INT NOT NULL,
RoomDesc VARCHAR(256),
CONSTRAINT Room_PK PRIMARY KEY (RoomID));

CREATE TABLE Instructor (
InstructorID INT NOT NULL,
DeptID INT NOT NULL,
HireDate DATE NOT NULL,
CONSTRAINT Instructor_PK PRIMARY KEY (InstructorID));

ALTER TABLE Enrollment
ADD FOREIGN KEY (ClassID)
REFERENCES Classes(ClassID);

ALTER TABLE Enrollment
ADD FOREIGN KEY (StudentID)
REFERENCES Student(StudentID);


run \| edit \| history \| help	0