Part II

Use only the data sets in the handout, "Some Possible Data Sets That Incorporate the Relationship Types in Figure $3\mathrm{.}3"($see the pages numbered $7$ or $13$ or $17$ or $22$ or $29-$ they are all the same $-$ of the Chapter $3$ handout materials$)$ to answer the following $22$ questions.

How is the relationship type Works$\_$in incorporated in the data sets shown in the handout? In other words, how is the fact that every employee works in a plant incorporated in the data sets shown in the handout?

Which projects are controlled by the Bellaire plant?

Which plants do not control a project?

Which project is not controlled by any plant?

How is the relationship type Managed$\_$by incorporated in the data sets shown in the handout? In other words, how is the fact that every plant has a manager incorporated in the data sets shown in the handout?

What is the plant number $($the plant number, not the plant name$)$ of the plant that employs Oswalt?

Counting the manager of each plant as an employee, which plant employs the greatest number of employees? How many employees work in this plant?

Which employees are not plant managers?

Who manages the Edloe plant?

Which employee$($s$)$ is $($are$)$ not assigned to any projects?