constructing a table(s) in SQL 2012
Posted on 2013-12-02
I have to get some advice again in constructing a table for my SQL database.
I need to list various Agencies. Each agency can have multiple Goals. Each goal can have multiple Objectives. Each Objective can have multiple Performance Indicators. Each Performance Indicator has a measure
Here is the beginning of my data list:
Should I have 3 separate tables with an AgencyID in each one? Does that mean I will have to inner Join my tables each time when selecting, updating and inserting them? Does that affect sql performance?
Need some advice. Btw, can you have too many tables in a database. I already have close to 30 tables. Some are big.