Question

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

Answer 1

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 2

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