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. Use rectangles to display the entities and their attributes and straight lines to show relationships.
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