Assignment

Create a Temporal Database based on a human resources database. It must have 3 dimension tables and 1 fact table. Use this database code as foundation.

Create Database HumanResoruces1

GO

use HumanResoruces1

GO

CREATE TABLE [Department]
(
[Department_ID] [int] NOT NULL,
[Department_Name] [nchar](50) NULL,
[Department_PhoneNumber] [nchar](25) NULL,
PRIMARY KEY (Department_ID)
);

CREATE TABLE [Employee]
(
[Employee_ID] [int] NOT NULL,
[Employee_FirstName] [nchar](50) NULL,
[Employee_LastName] [nchar](50) NULL,
[Employee_PositionID] [int] NOT NULL,
[Employee_Phone_Number] [nchar](10) NULL,
[Employee_SSN] [nchar] (9) NULL,
[Department_ID] [int] NOT NULL

PRIMARY KEY (Employee_ID)

FOREIGN KEY (Department_ID) REFERENCES Department(Department_ID),
);

CREATE TABLE [Employee_Job_Positions]
(
[Employee_PositionID] [int] NOT NULL,
[Job_Title] [nchar](50) NULL,
[Department_ID] [int] NOT NULL
PRIMARY KEY (Employee_PositionID)
FOREIGN KEY (Department_ID) REFERENCES Department(Department_ID)
);