Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions