There are several tables that require a starting time period and an
ending time period. Right now, that time period consists of a quarter
and a year, although that can change in the future.
From a normalization perspective, I think I should have a separate
TimePeriod table and link that table to the other tables that need
time periods. That will result in two joins each time we want to link
the TimePeriod table with another table (one join for StartingPeriod
and one join for EndingPeriod). But how will that affect performance?
From a performance perspective, should we just have the time period
fields in each of the tables where that data is needed?