(Solved) : Consider Following Relations Emp Eid Integer Ename String Age Integer Salary Real Works Ei Q30748926 . . .
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
Answer to Consider Following Relations Emp Eid Integer Ename String Age Integer Salary Real Works Ei Q30748926 . . .
OR