Creating dimensions

The company requires employees to take training yearly to stay up to date. As part of creating a report for HR employees and their training, it is necessary also to register the last date when the employee took the training. Your task is to introduce a new dimension to the model to document this event. Once you do this, it will finalize the fact table, linking together all the dimensions:

CREATE TABLE fact_employee_trainings (
    fact_id NUMBER(10,0) PRIMARY KEY,
    employee_id NUMBER(38,0),
    training_id NUMBER(38,0),
    date_id NUMBER(10,0), 
    FOREIGN KEY (employee_id) REFERENCES dim_employees(EMPLOYEE_ID),
    FOREIGN KEY (training_id) REFERENCES dim_trainings(TRAINING_ID),
      -- Waiting for the date dimension
    FOREIGN KEY (date_id) REFERENCES dim_date(date_id) 
);

Create, or replace if it already exists, a new dimensions dim_date.
Assign a unique identifier to the entity, called date_id.
Add attribute year and month, with data type NUMBER(4,0) and NUMBER(2,0), respectively, to keep the date records.

Exercise

Creating dimensions

Instructions

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise