Question (1) Answer each of the following questions
briefly.
These questions are based on the following relational
schema:
Emp(eid: integer, ename: string, age: integer, salary:
real)
Works(eid: integer, did: integer, pcttime: integer)
Dept(did: integer, dname: string, budget: real, managerid:
integer)
(a) (5 points) Give an example of a foreign key constraint
that involves the Dept relation. What are the options for enforcing
this constraint when a user attempts to delete a Dept tuple?
(b) (5 points) Write the SQL statements...