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 6 4 pts Suppose there is a new requirement that a certain Manager (e.g., Mojdeh) cannot get a discount for a certain product (e.g., Caviar). How do you modify the ER diagram in Figure 1 to capture this new requirement? A. Bold the line between the "Managers" entity set and the "Get discount" relationship set. B. We cannot modify the ER diagram to capture the new requirement. ER notations are defined on an entire entity set or an entire relationship set, not on specific entities nor specific relationships. invas.iastate.edu/courses/88970/quizzes/396887/take 9 T44:40 Quiz: Homework 1 - Part 1 C. Add a new entity set called "Special Managers" to hold all Managers entities with that special requirement (e.g., Mojdeh) in this entity set. Make this new entity set a sub- class of the "Managers" entity set via a new ISA relationship set. Add a new entity set called "Special Products to hold all special product entities (e.g., Caviar) and make the new entity set a sub-class of the Products" entity set via a new ISA relationship set. Create a relationship set called "not allowed" and draw a thin line to connect it to the "Special Managers" and "Special Products relationship set. D. None of the above
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