This is the link to the youtube videos :

CREATE TABLE sales (

    sales_id INT PRIMARY KEY,

    date_id INT ,

    product_id INT ,

    customer_id INT ,

    location_id INT ,

    promotion_id INT ,

    quantity_sold INT,

    amount_sold DECIMAL(10, 2)

)

CREATE TABLE product_dimension (

    product_id INT PRIMARY KEY,

    product_name VARCHAR(255),

    category VARCHAR(50),

    manufacturer VARCHAR(100)

)

CREATE TABLE customer_dimension (

    customer_id INT PRIMARY KEY,

    customer_name VARCHAR(255),

    city VARCHAR(100),

    country VARCHAR(100)

)

CREATE TABLE location_dimension (

    location_id INT PRIMARY KEY,

    location_name VARCHAR(255),

    city VARCHAR(100),

    state VARCHAR(50),

    country VARCHAR(100)

)

CREATE TABLE promotion_dimension (

    Promotion_id INt PRIMARY KEY,

    promotion_name VARCHAR(255),

    start_date DATE,

    end_date DATE,

    promotion_type VARCHAR(50)

)

CREATE TABLE date_dimension (

    date_id INT PRIMARY KEY,

    calendar_date DATE,

    day_of_week INT,

    month_name VARCHAR(10),

    year_num INT

)

INSERT INTO customer_dimension(customer_id,customer_name, city, country)

VALUES

    (1,’Customer 1′, ‘City 1’, ‘Country A’),

    (2,’Customer 2′, ‘City 2’, ‘Country B’),

    (3,’Customer 3′, ‘City 3’, ‘Country C’),

(4,’Customer 4′, ‘City 2’, ‘Country B’),

    (5,’Customer 5′, ‘City 2’, ‘Country B’),

    (6,’Customer 6′, ‘City 3’, ‘Country C’)

INSERT INTO date_dimension (date_id,calendar_date,day_of_week,month_name,year_num)

VALUES

    (1,’2022-01-01′, 1, ‘january’, 2022),

    (2,’2022-01-02′, 2, ‘january’, 2022),

    (4,’2022-02-01′, 1, ‘june’, 2022),

(5,’2022-02-01′, 1, ‘jully’, 2022),

(6,’2022-02-01′, 1, ‘february’, 2024),

(3,’2022-02-01′, 1, ‘december’, 2023)

INSERT INTO product_dimension (product_id,product_name,category,manufacturer)

VALUES

    (1,’Product A’, ‘Electronics’,’SONY’),

    (4,’Product B’, ‘Clothing’,’SAMSUNG’),

    (2,’Product D’, ‘Clothing’,’SAMSUNG’),

    (3,’Product A’, ‘Appliances’,’apple’),

(5,’Product C’, ‘Appliances’,’apple’),

(6,’Product A’, ‘Appliances’,’apple’)

INSERT INTO location_dimension (location_id,location_name, city, state,country)

VALUES

    (1,’Location 1′, ‘City 1′,’state 1’, ‘Country A’),

    (2,’Location 2′, ‘City 2′,’state 2′ ,’Country B’),

    (3,’Location 3′, ‘City 3′,’state 3′ ,’Country C’)

INSERT INTO promotion_dimension (promotion_id,promotion_name, start_date, end_date,promotion_type)

VALUES

    (1,’Promotion 1′, ‘2022-01-01’, ‘2022-01-31′,’promo1’),

    (2,’Promotion 2′, ‘2022-02-01’, ‘2022-02-28′,’promo 2’),

    (3,’Promotion 3′, ‘2022-03-01’, ‘2022-03-31′,’promo 3’)

INSERT INTO sales (sales_id,date_id, product_id, customer_id, promotion_id, quantity_sold, amount_sold)

VALUES

    (1, 1, 1, 1,1, 10, 100.00),

    (6, 2, 2, 2,2, 15, 150.50),

(2, 2, 2, 2,2, 15, 150.50),

    (3, 3, 3, 3,3, 20, 200.75),

    (4, 4, 4, 4,4, 20, 250.75),

(5, 5, 5, 1,1, 10, 150.00)