Question: Referential-integrity constraints as defined in this chapter involve exactly two relations. Consider a database that includes the following relations: salaried-worker (name, office, phone, salary) hourly-worker
Referential-integrity constraints as defined in this chapter involve exactly two relations. Consider a database that includes the following relations:
salaried-worker (name, office, phone, salary)
hourly-worker (name, hourly-wage)
address (name, street, city)
Suppose that we wish to require that every name that appears in address appear in either salaried-worker or hourly-worker, but not necessarily in both.
a. Propose syntax for expressing such constraints.
b. Discuss the actions that the system must take to enforce a constraint of this form.
Step by Step Solution
3.28 Rating (172 Votes )
There are 3 Steps involved in it
a For simplicity we present a variant of the SQL syntax As part of the create t... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
16-CS-DB (162).docx
120 KBs Word File
