USE SCHOOL
CREATE TABLE SC(
sno CHAR(5) REFERENCES Stu_Union (sno) on delete cascade,
cno CHAR(4) REFERENCES Course(cno) on delete cascade,
grade INT,
CONSTRAINT PK_SC PRIMARY KEY (sno,cno)
);
insert into sc values ('95002','0001',2);
insert into sc values ('95002','0002',2);
insert into sc values ('10001','0001',2);
insert into sc values ('10001','0002',2);
Select * From SC;