Given the CREATE TABLE statement below, add the following three constraints: – primary key constraint that (cid,sid) is a…

Given the CREATE TABLE statement below, add the following three constraints: – primary key constraint that (cid,sid) is a…

Question:

 

Transcribed Image Text:

Given the CREATE TABLE statement below, add the following three constraints:
– primary key constraint that (cid,sid) is a composite primary key.
– foreign key constraint that cid is a foreign key that references cid in the table course –
– constraint that Semester should be equal to “Sp21”
CREATE TABLE Registration
(cid INTEGER,
sid INTEGER,
Semester CHAR(10),
);

Expert Answer:

Answer rating: 100% (QA)

the modified CREATE TABLE statement with the added constr
View the full answer