Discuss the below:
Subject: Data Mining and Warehousing
Topic: Create an entity-relationship diagram using the conceptual data model.
Description: You are asked you to create a new entity-relationship diagram for a company (Moonlight Distributors) for a customized shipment tracking system.
Study level: BA
Q: Conceptual Model Entity Relationship Diagram
Required information below:
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.