Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

9th Edition

0135188148, 978-0135188149, 9781642087611

More Books

Students also viewed these Databases questions

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago