Results 1 to 2 of 2

Thread: Breaking data into table (and normalization)

  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Smile Breaking data into table (and normalization)

    I'm creating my first database driven website and I've read a lot, but most of the examples deal with customer ordering databases. I am working on a used car dealer site and I can of course create one big table, but I feel that it should be broken down, but outside of the category field, I don't see where I have redundant data. My initial thoughts are : CATEGORY, DETAILS, PHOTOS, but in reading normalization, this doesn't completely make sense.

    The fields that I need are as follows:

    Title, Engine, Color, Body_style, Transmission, Drive_train, Stock_number(primary key), Price, category (car, truck, etc...), features, fuel_type, VIN, thumb_photo_1, thumb_photo_2 , thumb_photo_3, thumb_photo_4, thumb_photo_5, photo_1, photo_2, photo_3, photo_4, photo_5.

    These fields will be present on two pages which can be seen at the following two links:

    http://kw-auto-sales.com/inventory.php

    http://kw-auto-sales.com/details1.php

    The page layout will change a bit, but for the most part this is it.

    Any help would be appreciated?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Photos field can be a separate table, that way you are not restricted by five photos.

Posting Permissions

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