Moonlight Distribution DB 1NF 2NF 3NF - 66016

Solution Posted by


Rating : (19)A+
Solution Detail
Price: $30.00
Request Description

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.


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.

Solution Description

Moonlight Dist DB.docx
Moonlight Dist ...
MoonlightDistributors - 1NF.vsd
MoonlightDistributors - 2NF.vsd
MoonlightDistributors - 3NF.vsd