Given the ER diagram in Figure 1 of Pak’s factory, answer the following a. In Pa

Question

Given the ER diagram in Figure 1 of Pak’s factory, answer the following

a. In Pak’s 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 Pak’s 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 Ingredients

Explanation / Answer

If you have any doubts, please give me comment...

a) No, Each manager must manage atleast one employee

b) 3 types, hourly_workers, fullTimeWorkers, Managers

c) A product is Of one ProducyType, A productType may have one or more Products

d) EmployeeID

e) purchase, make, Get_discount, bought_from

f) manage, Of

g) No, We can't give that type of constraints

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.