Question

10. Review the following ER-Diagram. Write the missing part of the SQL statement to define a foreign key that links the course table with the department table. Course Table PK CourseID CourseName FK DepartmentID Department Table PK DepartmentID DepartmentName FK HeadOfDepartment CREATE TABLE Course( courseID int NOT NULL, courseName VARCHAR(50), PRIMARY KEY (courseID), () () );

          10. Review the following ER-Diagram. Write the missing part of the SQL statement to define a foreign key that links the course table with the department table.
Course Table
PK CourseID
CourseName
FK DepartmentID
Department Table
PK DepartmentID
DepartmentName
FK HeadOfDepartment
CREATE TABLE Course(
courseID int NOT NULL, courseName VARCHAR(50), PRIMARY KEY (courseID),
____ ____(____) ____ ____ (____)
);

10. Review the following ER-Diagram. Write the missing part of the SQL statement to define a foreign key that links the course table with the department table.
Course Table
PK CourseID
CourseName
FK DepartmentID
Department Table
PK DepartmentID
DepartmentName
FK HeadOfDepartment
CREATE TABLE Course(
courseID int NOT NULL, courseName VARCHAR(50), PRIMARY KEY (courseID),
() ()
);

Added by Stephanie H.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Sri K

06/11/2023

Step 1

We need to link the `Course` table with the `Department` table using a foreign key. This means that the `DepartmentID` in the `Course` table should reference the `DepartmentID` in the `Department` table. Show more…

Show all steps

Thanks for your feedback!

Review the following ER-Diagram. Write the missing part of the SQL statement to define a foreign key that links the course table with the department table. Course Table PK CourseID CourseName FK DepartmentID Department Table PK DepartmentID DepartmentName HeadOfDepartment CREATE TABLE Course ( CourseID int NOT NULL, CourseName VARCHAR(50), DepartmentID int, PRIMARY KEY (CourseID), FOREIGN KEY (DepartmentID) REFERENCES Department(DepartmentID) );