Moonlight Distributer database in 1st Normal Form 1. We have eliminated the duplicate column, Consignee Information, from the tables, Pickup manifest and Delivery Manifest 2. Similarly the Payment Methods has been moved to new table as it was duplicate column in the tables, Pickup manifest and Delivery Manifest 3. All the tables are identified by unique key called as primary key a. Pickup Manifest - PICKUP_ID b. Consignee Information - CONSIGNEE_ID c. Delivery Manifest - DELIVERY_ID d. Payment Methods - PAYEMENT_ID e. Delivery Truck Details - TRUCK_ID Moonlight Distributer database in 2nd Normal Form 1. Remove the subsets of the data, List of delivery manifests from the table TRUCK_DTLS in a separate table called as TRUCK_DELIVERY which would uniquely identify the DELIVERY_MANIFEST details for each truck in TRUCK_DTLS table. 2. Created relationships between table using foreign keys a ...
Purchase document to see full attachment