Question: Movers Savers (MS) is a medium sized company offering moving serivces for the Chicago area. The company has a staff of employees that take on

Movers Savers (MS) is a medium sized company offering moving serivces for the Chicago area. The company has a staff of employees that take on different roles such as estimator, packer, and driver. The estimators review the contents of a customers house or apartment and create a moving order. The moving order shows the starting address and ending address including apartment number and floor it is on, the number of furniture pieces, number of standard boxes and the number of extra sized boxes to be moved along with the pickup and dropoff dates and times. A total price is provided for the entire order.
One or more moving trucks (with the year, make, model, miles, and storage capacity) will be assigned to each moving order and one or more employees will be assigned to do the work outlined in the moving order. Because employees can work on different moving orders and are paid an hourly wage, we should also keep track of how many hours each employee spends working on each moving order.
Create an E-R diagram with all the entities, attributes, identifiers, and relationships. Be sure all relationships are labeled appropriately with verb phrases.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!