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

1 Expert Approved Answer
Step: 1 Unlock

a For simplicity we present a variant of the SQL syntax As part of the create t... View full answer

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

Document Format (1 attachment)

Word file Icon

16-CS-DB (162).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!