CREATE TABLE Forecasts
(
SalesPersonId int,
Year int,
AmountJan money,
AmountFeb money,
......
AmountDec money
)
ALTER TABLE Forecasts ADD 
(CONSTRAINT FKY_Forecasts_1
FOREIGN KEY (SalesPersonId )
REFERENCES SalesPersons (SalesPersonId )
)

CREATE TABLE Forecasts
(
SalesPersonId int,
Year int,
ForecastId int
)
ALTER TABLE Forecasts ADD 
(CONSTRAINT FKY_Forecasts_1
FOREIGN KEY (SalesPersonId )
REFERENCES SalesPersons (SalesPersonId )
)

CREATE TABLE MonthlyForecast
(
ForecastId int,
Month int,
Amount money
)
ALTER TABLE MonthlyForecast ADD 
(CONSTRAINT FKY_MonthlyForecast_1
FOREIGN KEY (ForecastId )
REFERENCES Forecasts (ForecastId )
)