Part II

Use the data in the handout, "Some Possible Data Sets That Incorporate the Relationship Types in Figure $3\mathrm{.}3"$ 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

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$.,$ assum none of the other deletion constraints exist for the moment$),$ what modification would have to $b$ made to the data in the PROJECT data set shown in the handout "Some Possible Data Sets Th: Incorporate the Relationship Types in Figure $3\mathrm{.}3"$ before an attempt is made to delete the Aberdec plant? At the moment, the data in the PROJECT data set included the project number, proje name, and name of the plant the controls the project.