I need a database designing from new for storing car information i have gathered. It needs to be designed from new and have the following.
* Page for new specifications to be added (specs are stored now in .txt files) so this page needs to be able to input the specs from the .txt file into the databse.
* Page to edit and control the specs
* Page to display the specs to a html file. The page needs to contain. The Makes and models of cars listed in the database. A search facility to let viewers search for there car. Top 10 cars views and Top 10 new cars added.
Here is an example of the information to be stored to the db.
Fiat Stilo 1.2
FUEL TYPE: petrol (gasoline)
ENGINE CAPACITY: 1242cc
CYLINDERS: In-line 4
TORQUE: 84 lb-ft
DRIVEN WHEELS: front (FWD)
STANDARD TRANSMISSION: 6-speed manual
OPTIONAL TRANSMISSION: none
BODY STYLES: 3/5-door hatchback
SEATING CAPACITY: 5
MAXIMUM SPEED: 106mph
0-60: 13.4 seconds
AVERAGE FUEL ECONOMY: 43mpg
LENGTH: 4253mm [167.4 in]
WIDTH: 1756mm [69.1 in]
HEIGHT: 1525mm [60.0 in]
WHEELBASE: 2600mm [102.4 in]
KERB WEIGHT: 1090kg [2401lbs]
CO2 EMISSIONS: 155 g/km
UK INSURANCE GROUP: 4
EURO NCAP CRASH TEST RATING: 4 stars
US NCAP (NHTSA) CRASH TEST RATING: not applicable
This is how the specs are saved in the .txt files.
here is some exaples of other sites with these kind databases.http://www.mymotorguide.com/http://www.automotive.com/new-cars/specifications/index.html
Any questions please contact me