I am woundering whether someone has time to normalize my database?
I dont know if it needs normalization, but I want to do everything perfectly, and I dont know if it is already good or not.
I have used phpMyAdmin to create my database...
Background: Im making a classifieds website. One category of ads is 'cars'. So far, I have created the database for cars only, i thought it might be good to begin with cars simply...
Here is the table: (only one table)
- id (AI) (INT(7))
- area_id (VARCHAR(30))
- area_community (VARCHAR(30))
- price (INT(9))
- year (INT(4))
- mile (INT(6))
- gearbox (VARCHAR(12))
- fuel (VARCHAR(12))
- insert_date (TIMESTAMP)
- poster_name (VARCHAR(30))
- poster_email (VARCHAR(30))
- poster_tel (VARCHAR(20))
- poster_password (VARCHAR(15))
- poster_zip (INT(5))
- private_or_company (INT(2))
- headline (VARCHAR(60))
- description (TEXT)
- sell_or_buy (INT(2))
- nr_of_pics (INT(2))
I will update this post everytime you need more input if thats the case... I have read a couple of articles about normalization, I get the concept, but dont really know how to put it to practice.
Thanks alot!
UPDATE OK, so splitting out is the deal here... So say I have splitted poster out to a separate table. How do I link the 'poster_table' to the first table? That is, if the user clicks an ad, and then the ad will have to be displayed, along side poster name, date, area etc etc... So there has to be a way to link them, am I right?