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.

Question

Suresh Chand · Accepted Answer

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

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.

Leave your Answer:

Hits Counter

Question

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.

Leave your Answer: