SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 Learning normalization :)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Oggie25
Starting Member

United Kingdom
1 Posts

Posted - 11/09/2012 :  17:59:57  Show Profile  Reply with Quote

Currently I am trying to learn database normalization which is not very easy for me to understand. I found some data examples and I was trying to do normalization but I am not sure that I am doing it correctly.

What I found is :

Trip_id
Departure
Return
Duration
Driver_first_name
Driver_last_name
Vehicle_registration
Manifest_barcode
Item_weight
Pickup_customer
Delivery_customer
Category
Description
Requirements

What I end up with is :

(1NF)
Trip_id-------Primary key
Departure
Return
Duration
Driver_first_name
Driver_last_name
Vehicle_registration
Manifest_barcode
Item_weight
Pickup_customer
Delivery_customer
Category
Description
Requirements


(2NF)
Trip_id--------Primary key
Departure
Return
Duration
Driver_first_name
Driver_last_name
Vehicle_registration


Trip_id-----------------Primary key
Manifest_barcode-------Primary key
Item_weight
Pickup_customer
Delivery_customer
Category
Description
requirements





(3NF)
Trip_id-----------Primary key
Departure
Return
Duration
Driver_first_name
Driver_last_name


Trip_id----------------Primary key
Manifest_barcode-----------Foreign key
Item_weight
Pickup_customer
Delivery_customer


Manifest_barcode-----------Primary key
Vehicle_registration------------Foregin key
Category
Description
Requirements


Is this right ?
or I am doing something wrong and WHY?

Thanks
Edit/Delete Message
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000