Question
Given the ER diagram in Figure 1 of Paks factory, answer the following a. In Paks factory, is it possible that a manager does not
Given the ER diagram in Figure 1 of Paks factory, answer the following
a. In Paks factory, is it possible that a manager does not have any employees he/she manages? Explain which ER notation gives you the answer.
b. How many types of employees there are in Paks factory and what are they?
c. Examine the relationship set of between Products and Product Types, write in English all the constraints related to this relationship set as indicated by the ER notations.
d.Which attribute is a key attribute of the entity set Hourly_Workers?
e. List all m:n relationship sets in the ER diagram.
f. List all 1:n relationship sets in the ER diagram.
g. Is it possible to use existing ER diagram notations to enforce a constraint that a particular product is not allowed to be made by certain hourly workers? If yes, provide the notation that illustrates the constraint. If no, provide the reasons why it is not possible in the ER diagram.
illustrates the constraint. ir no, provide the reasons why it is not possible in the E diagram. phone no. manage Employees phone no. specialty Hourly_Workers FullTime_WorkersManagers alary salary Workers and Qaitypurchase ake Managers cover Employews fulitime workers, and Menagers are not Products bought from Suppliers Of IngredientsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started