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),
    PRIMARY KEY (CID)
)

-- 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.

Discussion
0 Comments
  Loading . . .