what tables to use in insurance website database?

busby

hello

im creating a vehicle insurance website for a university project.

its going to be an online profile site similar to http://www.swiftcover.com

where users create a profile which stores their personal and vehicle data and they can view and edit their policy at any time and submit claims and view certificate etc.

my only question is...what tables would i need for the database?

would i have a customer table storing all their personal info and their username and password.

then a vehicle table storing all vehicle info connected to the customer table via the C_ID

would the customer table be connected to the vehicle table via the V_ID?

what other tables would i need?

i dont know why but i just cant picture the database in my head and i think once i know the tables i can continue on my own

jeepin81

I would do a google search for "relational database design" and read up on that.

That should get you pointed in the right direction, plus you'll actually learn from it, instead of someone one doing the work for you. you're on the right track though.

busby

i only asked for the tables needed...no work is being done for me as for looking up relational databases...i know wot a relational database is i know how to make one and how to make it work with a website.

im not asking for ANY work to be done

the question i was asking was what tables i needed in the database. other than customer and vehicle.

turns out i got the answer from posting the same question on another forum...thanks anyay for insulting me and pointing me in the wrong direction.

dagon

busby, Methinks you doth protest too much. You ask for a lot based on so very little. I would expect a few dozen pages spec before i could contemplate the db structure for such a project.

jeepin81

how did I point you in the wrong direction?? If so, what was the answer? also, if you're astute in your query, why did you ask?

I'm not trying to be an ass, I really want to know.