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 8 4 pts Suppose a requirement is added such that each entity in the Employees entity set either has no manager or at most one manager in the Managers" entity set, What needs to be done to the ER diagram in Figure 1 to ensure that this requirement is indicated in the diagram? A. Nothing needs to be done to the ER diagram in Figure 1. B. Add an arrow to the line between Managers" entity set to the "manage" relationship set. invas.jastate.edu/courses/88970/quizzes/396887/take 9 14:40 Quiz: Homework 1 - Part 1 C. Change the bold line to a non-bold line between the "Managers" entity set and the "manage" relationship set. D. Bold the line connecting the "Employees" entity set to the "manage" relationship 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