Company offers 3 types of personal motor insurance to vehicle owners. It includes the third party insurance, fire and theft, and comprehensive cover. All vehicle owners need to purchase a motor insurance which covers their vehicles, be it a motorcycle, a car, or a lorry, in case of accidents or thefts. All motor insurance is identified by a unique policy number, date of purchase, date of expiry, coverage amount, premium amount and type of insurance, vehicle identification and owner identification. The third party insurance covers the liabilities to third party for injury, death and damage, while fire and theft covers an additional loss or damage to own vehicle due to accidental fire or theft. Lastly, the comprehensive insurance will cover all components of the previous two plus damage to own vehicle due to accident.

enter image description here

Is this correct?if not how can I modify it?

  • Have you tried anything, i.e. worked out any tables that you already figured out? Or are you expecting the community to solve it for you? – koljanep Mar 24 '15 at 16:19
  • Worked solution...but i m not sure if ok – DBAStudent Mar 24 '15 at 16:34
  • I included insurance type in insurance class then made another class and put their insurance covers and policynum – DBAStudent Mar 24 '15 at 16:35
  • 1
    @DBAStudent Try editing your post with what you've gotten for a design so far and we can go from there. – LowlyDBA Mar 24 '15 at 16:40
  • @please check now – DBAStudent Mar 24 '15 at 17:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.