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!!!