-
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?
-
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
-
Forum Rules
|
|