Conceptual Data Model first run, help needed!

[sports_brah]

Here's my CDM, for an online insurance company.

On a scale from 1-10 how wrong am I? Any tips you could give? Thank you.

 

[peterwalkley]

ADDRESS_ID (FK) seems to be duplicated all over the place. Surely the address is a simple select via the CUSTOMER table ?

What's the point of the INSURANCE_TYPE table ? The type is implicit from the life, travel, health, pet etc tables.

BUY NOW and BUY LATER tables look identical. Why not use the same table and a flag for the type (or a date) ?

EDIT: Not saying any of this is wrong - just asking the questions from zero knowledge of the requirements, but some guesswork on assumptions instead.
.. and wrong forum. Programming would be better.

 

[sports_brah]

Thanks for writing that!

I put address separately as on online sites you have to enter it all, and there are dropdown lists of all the counties and then towns etc (obviously to help narrow down your area for their insurance rating). Can this be handled within an entity with loads of other stuff? (I'm new to this!)

The insurance type was put there because I thought that there would need to be some selector of what type of insurance there would be at the start? I'm guessing I'm not thinking right in database terms.

Good call on the buy now and buy later ones, I just wasn't sure how you'd separate them, seeing as some retrieve quotes to order later whereas some buy instantly.

(I'm not a database guy!)

 

[sports_brah]

Anyone got any last min tidbits of advice? Thanks