Consider the following relations:
Emp(E_id: integer, E_name: string,Age: integer, Salary: real)
Works(E_id: integer, Dep_id: integer, affectation: date)
Dept(Dep_id: integer, Dep_name: string, budget: real, Manager_id:integer)
What referential integrity constraints exist between theserelations?
What are the options for enforcing these constraints when a userattempts to delete a Dept tuple?
Expert Answer
An answer will be send to you shortly. . . . .