AnsweredAssumed Answered

Tricky db setup question

Question asked by JammieSchmunk on Feb 14, 2015
Latest reply on Feb 21, 2015 by FentonJones


Tricky db setup question


I am designing a db to track a company's insurance policies.

  • 1 company has many subsidiaries and each subsidiaries have many locations which has many different buildings.
  • 1 company has many different policies which has many different coverages, claims, assets, etc.
  • The 2 main tables are company and policies yet lots of tables coming out of policy. What is the best way to set that up? 

The way it's set up needs to be redone...I'm just not sure how to structure it. 
Any help would be GREATLY appreciated!!!