Answered step by step
Verified Expert Solution
Question
1 Approved Answer
address phone no. Firstname Lastname Employee manage Employees address phone no. HoursPer Week MaxSupervisi ngCapacity specialty Firstname ISA Lastname CustID Hourly_Workers FullTime_Workers Managers Customers HourlyWage
address phone no. Firstname Lastname Employee manage Employees address phone no. HoursPer Week MaxSupervisi ngCapacity specialty Firstname ISA Lastname CustID Hourly_Workers FullTime_Workers Managers Customers HourlyWage title salary salary Quantity discountAmt purchase make Hourly_Workers, Full Time_Workers, and Managers cover Employees. Hourly_Workers Fulltime_Workers, and Managers are not overlapped. Get_discount Products Price address QTY SupplierName ItemID Name RemainingQTY bought from Suppliers Of DateOfPurchase Price TypeName Ingredients Product Types ItemID description Figure 1: ER diagram of Pak's food factory Question 7 4 pts Suppose a database requirement is added to the ER diagram in Figure 1 such that each entity in the "Hourly_Workers entity set must make exactly one product in the Products entity set. A. No change in the ER diagram is needed since the current diagram already indicates the new requirement. B. Draw the line with the arrow originating from "Hourly_Workers" and ending at "make", and bold the line. C. Bold the line between the "Hourly Worker" and "make". D. Add a thin arrow originating from Hourly_Workers" and ending at "make". E. Draw the arrow originated from "Products" and ends at Makes", and bold the line to indicate total participation of the "Products" entity set
Step 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