DBMS
(on delete set null, on delete cascade )
Tom, the administrator should create the table "CSR_Registration" with the following rules
Whenever a row in the CSR_Student table is deleted, the row from the CSR_Registration must be deleted
When deleting the row from the CSR_course table link column of the CSR_registration must be made to null
Drag and drop the correct keyword for the below given query.
create table CSR_registration(courseid number(4) references CSR_course(courseid)
,studid number(4) references CSR_student(studid)
,doj date);
Answers
Answer:
create table CSR_registration(courseid number(4) references CSR_course(courseid)
on delete set null
,studid number(4) references CSR_student(studid)
on delete cascade
,doj date);
Explanation:
Answer:- The algorithm with the steps to create the given table are written below. Please go through the full answer.
The step 1:- To Create the Student table write these fuctions
CREATE TABLE Student (
sno INT PRIMARY KEY,
sname Anita(20),
age INT
);
The step 2:- Insert rows into the given Student table
INSERT INTO Students(s-no, students-name, age)
VALUES(1,'Rahul',19),
(2,'Mina',20),
(3,'Ritika',19);
The step 3:- Execute the SELECT query to check the given data in the STUDENT table.
SELECT *
FROM Student;
The output of the given program will be:-
Serial no. student name age
1 Rahul 19
2 Mina 20
3 Ritika 19
Hope this will be helpful to you.
To know more about the given topic please go through the following
Link1:- https://brainly.in/question/15442524?
Link2:- https://brainly.in/question/14590465?
#SPJ3