make an Entity Relations model for a business case and then convert the model to a set of relations.

1)  Need an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data.

·       All relationships should be labeled with verb phrases.

·       Use UML notation for this work.

·       Relationship lines should be straight and should not cross.

2)  Write out two "relationship sentences" for each relationship using the format:

One may be (or must be) one (or many)

3)  Once your ER model is completed, Convert the ER model to a set of Relations.

·       Clearly indicate a key (key) and any foreign keys (fk) for each Relation. Each relation should only be shown one time.

Business Case: NYBM case

NYBM is a medium sized company offering moving services for the NY 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 customer's house or apartment and place 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, the 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.