Question: 3 ) Write a SQL query to create two tables: one for university departments and another for courses. Ensure that the course table includes a
Write a SQL query to create two tables: one for university departments and another for courses. Ensure that the course table includes a foreign key constraint on the department name, with both delete and update actions set to cascadeInsert data into the department and course tablesDrop constraint foreign key and then add constraint again for the foreign key with on delete no action.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
