Consider the Student schema
Create table Student (id Integer primary key, Name varchar(50));
Create table Course (Courseid Integer primary key, id Integer references Student(id) on delete cascade);
Create table Marks(mark Integer primary key,Courseid Integer references Course(Courseid) on delete NULL);
INSERT INTO Student VALUES (1, 'Ajay');
INSERT INTO Student VALUES (2, 'Vijay');
INSERT INTO Course VALUES (11, 1);
INSERT INTO Course VALUES (22, 1);
INSERT INTO Marks VALUES (100, 22);
INSERT INTO Marks VALUES (200, 22);
Delete Student;
What tuples will be in the DB in any relation after completion of above Queries?1
(1, NULL), (2, NULL)
2
(100, NULL)
3
(11, NULL) (22, NULL)
4
(200, NULL)