I am fairly new to mysql and wanted to practice making a database and tables. As well as filling the tables with made up data and then practicing queries. I wanted to emulate a real life database project.

So I decided to make a database for a Car Dealership.

the database consists of three tables...Car...Buyer..Repairs. The structure is displayed below.


CAR table -

car_id int(5) primary key
make varchar(15)
model varchar(15)
year int(4)
origin varchar(15)
buyer int(5) foreign key references buyer_id in the BUYER table
cost double(5,2)



BUYER table -

buyer_id int(5) primary key
name varchar(20)
address varchar(20)
tel int(10)
car_id int(5) foreign key references car_id in the CAR table


REPAIRS table-

part_id int(5) primary key
origin varchar(15)
cost double(5,2)
car_id int(5) foreign key references car_id in the CAR table




Do you see any problems in this structure?
anything I should have done differently?
anything I could do to improve database performance?

Please bare with me as I am new to this and wish to be a DBA one day soon!

All comments will be appreciated!!

Thanks people

The "repairs" table is a little simplistic for a real application but it will be Ok for practise. Performance is more how you structure the queries rather than the tables, provided of course you keep the redundancy down to an absolute minimum (or none).

BTW it's "bear with me" as "bare with me" would involve a mutual removal of clothing and I guess that is not what you meant

Hmm.... It will work bro. Make things easy for users and you will have awesome results. Best of luck.

As long as the database is built to hold all the information you will need, then that is all you will need. The only thing I would suggest though, is always adding an id with the auto increment feature to every table. This way everything entered into a table will be given a unique id in case you ever need to sort them this way. If you don't ever need to, it won't hurt having it, just don't use it.

In the future, your sure to want to make changes to all sites, and having the id field will truly come in handy more than you realize now.

Thanks!!

I have taken all your replies on board and will adjust the database accordingly.

lol BEAR with me..apologies..lets not all get naked!


Appreciate the replies

The "bare" thing is funny. But good you figured it out, best of luck!