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 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

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

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions

Question

How do economists try to disentangle cause and effect?

Answered: 1 week ago

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago