Question

II. Fill in the blanks: (30 The relational database schema of Course Management System are defined as follows: Department (ID, Name, Head) Teacher (ID, Name, Position, DeptID) Student (ID, Name, Gender, Birthday, DeptID) Course (ID, Name, Room, TeacherID) Enroll (StudentID, CourseID, Grade) Please fill the blanks in the following SQL statements. 1. Create the Enroll table. CREATE TABLE Enroll ( char (8) NOT NULL StudentID [1] char (4) NOT NULL CourseID [2] int Grade CHECK (Grade IS NULL OR (Grade>-0 AND Grade=100)), [3] 2. Create an index for teacher name. CREATE INDEX teacher_name_idx ON [4] it 3. Insert a student in department "001" INSERT INTO Student ( [51

Answer 1

[1]  FOREIGN KEY ( StudentID )REFERENCES Student(ID) //as student ID will be a primary key in student table it ii a foreign key here

[2] FOREIGN KEY(CourseID) REFERENCES Course(ID) //as Course ID will be a primary key in Course table

[3] //Not clearly specified in question and the above two statements serve the same perpose

[4] CREATE INDEX teacher_name_idx ON Teacher(Name);

[5] INSERT INTO Student(ID, Name, Gender, Birthday, DeptID)

VALUES('43', 'SAM', 'MALE, '12/09/1998', '001')