Database Management System20825 marksSQL data definition language
Write SQL statements to create a table and update value in a table. Also mention the use of cascade on delete while creating the table. Use your own assumption for the table and update conditions.
Write SQL statements to create a table and update value in a table. Also mention the use of cascade on delete while creating the table. Use your own assumption for the table and update conditions. [5]
Explanation of each clause: Clause Purpose ------ PRIMARY KEY Uniquely identifies each row in the table NOT NULL Ensures the column cannot have a NULL value FOREIGN KEY Creates a referential link between Employee.deptid and Department.deptid ON DELETE CASCADE Automatically deletes all related row...