Create two table Courses (CID, Course, Dept) and HoD (Dept, Head) using SQL language with all constraints [Primary key, Foreign key and Referential Integrity]. Assume the types of attributes by your own.

This answer is restricted. Please login to view the answer of this question.

Login Now

We will create a table with Course, and HoD using SQL. The SQL code is given below:

-- Create Table "Course":
CREATE table Courses (
    CID INT(11),
    Course varchar(50),
    Dept varchar(70),

-- Create Table "HoD":
CREATE table HoD (
    Dept varchar(70)
    Head TEXT,
    FOREIGN KEY (Dept) REFERENCES Course(Dept)
If you found any type of error on the answer then please mention on the comment or report an answer or submit your new answer.
Leave your Answer:

Click here to submit your answer.

  Loading . . .