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.

  • 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.
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.