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

3)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 cascade.4)Insert data into the department and course tables.5)Drop 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!