Referential-integrity constraints as defined in this chapter involve exactly two relations. Consider a database that includes the

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 (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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: