Homework Opportunity No$.8$

Use the data in the handout, "Some Possible Data Sets That Incorporate the Relationship Types in Figure $3\mathrm{.}3"$

$($page $7$ or $13$ or $17$ or $22$ or $29)$ in the Chapter $3$ Handout Materials$)$ plus the deletion constraints that appear in

Figure $3\mathrm{.}8($page $105$ in the textbook$)$ and Table $3\mathrm{.}1$ to answer the following seven questions. Note: the focus

of these questions is on Figure $3\mathrm{.}8$ which contains a resolution of the conflict involving deletion constraints

$7$ and $8.$ Please answer these questions on a separate sheet. It is not necessary that you retype the questions. I

know what they are.

As mentioned above, Figure $3\mathrm{.}8$ contains a resolution of the conflict associated with deletion constraints $7$

and $8.$ Which of these two deletion constraints is reflected in Figure $3\mathrm{.}8?$

What is the impact of deletion constraint $11$ when an attempt is made to delete the dependent of Biggio?

What is the impact of deletion constraint $12$ when at attempt is made to delete the quilting hobby?

Consider only deletion constraint $2$ on the first part of this question.

What is the impact of deletion constraint $2$ when an attempt is made to delete Kent as an

employee?

Does your answer change when we take into consideration that Kent is assigned to several

projects and other relevant deletion constraints are considered?

Assume that somehow all of the employees of the Aberdeen plant have been deleted and its manager

transferred to another plant. Using Figure $3\mathrm{.}8$ and considering only deletion constraint $3($i$.$e$.,$ assume

none of the other deletion constraints exist for the moment$),$ what modification would have to be

made to the data in the PROJECT data set shown in the handout "Some Possible Data Sets That

Incorporate the Relationship Types in Figure $3\mathrm{.}3"$ before an attempt is made to delete the Aberdeen

plant? At the moment, the data in the PROJECT data set included the project number, project

name, and name of the plant the controls the project.