Results 1 to 3 of 3

Thread: normalization

  1. #1
    Join Date
    Nov 2012
    Posts
    2

    normalization

    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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,445
    close
    bear in mind you do not want to repeat information so you need to revisit at least TripID
    Fundamentals of Relational Database Design -- r937.com
    The Relational Data Model, Normalisation and effective Database Design
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2013
    Location
    Poland
    Posts
    3
    Quote Originally Posted by healdem View Post
    close
    bear in mind you do not want to repeat information so you need to revisit at least TripID
    Fundamentals of Relational Database Design -- r937.com
    The Relational Data Model, Normalisation and effective Database Design
    Very good resources. Helped me a lot! Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •