Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Madelin
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...
TSQL - Unique string generator
hhhhhhhhhhh
food_plan
Xml Excercise 2
gfhrey
af
MyDb
Exam