Browse over 20 million
homework answers & study documents

Computer Science

Moonlight Distribution DB 1NF 2NF 3NF

Type

Lab

Rating

Showing Page:
1/3
Moonlight Distributer database in 1
st
Normal Form
1. We have eliminated the duplicate column, Consignee Informaon, 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 iden&ed by unique key called as primary key
a. Pickup Manifest – PICKUP_ID
b. Consignee Informaon – CONSIGNEE_ID
c. Delivery Manifest – DELIVERY_ID
d. Payment Methods – PAYEMENT_ID
e. Delivery Truck Details – TRUCK_ID

Sign up to view the full document!

lock_open Sign Up

Sign up to view the full document!

lock_open Sign Up

Sign up to view the full document!

lock_open Sign Up

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Document I purchased was really helpful. Had answers to help me with my hmw.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4