TimesheetID int, CONSTRAINT PK_WorkHours PRIMARY KEY (EmpID, ProjectID, WH_Day, WH_Month, WH_Year), CONSTRAINT FK_WorkHoursEmployees FOREIGN KEY (EmpID) REFERENCES Employees, CONSTRAINT FK_WorkHoursProjects FOREIGN KEY (ProjectID) REFERENCES Projects, CONSTRAINT FK_WorkHoursTimesheets FOREIGN KEY (TimesheetID) REFERENCES Timesheets) CREATE BenefitsTaken int not null, BenefitTypeID int not null, BT_Day int not null, BT_Month int not null, BT_Year int not null, HoursTaken float, TimesheetID int, CONSTRAINT PK_BenefitsTaken PRIMARY KEY BenefitTypeID, BT_Day, BT_Month, BT_Year), CONSTRAINT FK_BenefitsTakenEmployees FOREIGN KEY (EmpID) REFERENCES Employees, CONSTRAINT FK_BenefitsTakenBenefitTypes FOREIGN KEY (BenefitTypeID) REFERENCES BenefitTypes, CONSTRAINT FK_BenefitsTakenTimesheets FOREIGN KEY (TimesheetID) REFERENCES Timesheets) Data Section The following information is currently maintained in various spreadsheets throughout CMS. Data from these spreadsheets must be uploaded into your newly created tables before the database can be considered operational. REGIONS ID Abbr. Region Name 1 NAR America 2 CALA Central and Latin America 3 APAC Asia and Pacific 4 EMEA Europe, Middle East, and Africa COUNTRIES ID Country Name Weekly Hours Holidays Vacation Days Region 1 United States 40 11 10 NAR
TimesheetID int, CONSTRAINT PK_WorkHours PRIMARY KEY (EmpID, ProjectID, WH_Day, WH_Month, WH_Year), CONSTRAINT FK_WorkHoursEmployees FOREIGN KEY (EmpID) REFERENCES Employees, CONSTRAINT FK_WorkHoursProjects FOREIGN KEY (ProjectID) REFERENCES Projects, CONSTRAINT FK_WorkHoursTimesheets FOREIGN KEY (TimesheetID) REFERENCES Timesheets) CREATE BenefitsTaken int not null, BenefitTypeID int not null, BT_Day int not null, BT_Month int not null, BT_Year int not null, HoursTaken float, TimesheetID int, CONSTRAINT PK_BenefitsTaken PRIMARY KEY BenefitTypeID, BT_Day, BT_Month, BT_Year), CONSTRAINT FK_BenefitsTakenEmployees FOREIGN KEY (EmpID) REFERENCES Employees, CONSTRAINT FK_BenefitsTakenBenefitTypes FOREIGN KEY (BenefitTypeID) REFERENCES BenefitTypes, CONSTRAINT FK_BenefitsTakenTimesheets FOREIGN KEY (TimesheetID) REFERENCES Timesheets) Data Section The following information is currently maintained in various spreadsheets throughout CMS. Data from these spreadsheets must be uploaded into your newly created tables before the database can be considered operational. REGIONS ID Abbr. Region Name 1 NAR America 2 CALA Central and Latin America 3 APAC Asia and Pacific 4 EMEA Europe, Middle East, and Africa COUNTRIES ID Country Name Weekly Hours Holidays Vacation Days Region 1 United States 40 11 10 NAR
1799_CMS-Project-Phase-II-Instructions-3-.docx