Your supervisor has asked you to create a new entity-relationship diagram for a company called Moonlight Distributors for what would be a customized shipment tracking system. Use the information below to develop the diagram.
Conceptual Model
Pickup Manifest
Customer information
Pickup details
Consignee information
Payment methods
Delivery Truck Details
Route number
Driver’s name
Employee ID
Time logged out
List of delivery manifests
Delivery Manifest
Consignee information
Delivery details
Payment methods
Condition of goods delivered
Date of delivery
Consignee signature
Problems with delivery
Assignment Guidelines
Create an entity-relationship diagram using the conceptual data model located in the assignment description.
Paste your ER diagram into a Word document, and save it as U1A1LastName.
Your submitted assignment (125 points) must include the following:
A Word document containing your entity-relationship diagram named U1A1LastName.
Grading:
You will be graded on how accurately your entity-relationship diagram is modeled with regard to the information in the Assignment Description.
Please submit your assignment.