In the General Hardware Corp. database of Figure 6.1, what would happen if: a. The delete rule

Question:

In the General Hardware Corp. database of Figure 6.1, what would happen if:

a. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?

b. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?

c. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-tonull and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?

d. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?

e. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?

f. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-tonull and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?

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

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: