Question details

Data Mining and Warehousing - - High Level Project Plan
$ 10.00

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.

Available solutions