database Modeling
r this homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations.
1) Read through the following business case for the “NY Best Move” company.
2) Create 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.
3) Write out two “relationship sentences” for each relationship using the format:
One may be (or must be) one (or many)
4) 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 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, 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.
Assignment Submission
What you will be submitted to Blackboard:
1. An E-R diagram with all of the entities, attributes, identifiers and relationships. Be sure all relationships are labeled appropriately with verb phrases and the diagram includes an appropriate legend (Name of the Model, Created by, Date/Time, Your Name and Course information, etc.)
2. A set of “Relationship Sentences”
3. The initial set of relations resulting from the conversion from E-R model to relational model. Clearly indicate keys and foreign keys.
