a/b)


PK_TIME int PRIMARY KEY not null,
Rok int,
Miesiac varchar(50),
Dzien varchar(50),
DzienMiesiaca int
)

CREATE TABLE MONTHS
(
    nazwa varchar(50) not null,
    liczba int

)

CREATE TABLE DAYS
(
    nazwa varchar(50) not null,
    liczba int
)

INSERT INTO MONTHS VALUES ('styczen',1),('luty',2),('marzec',3),('kwiecien',4),('maj',5),
('czerwiec',6),('lipiec',7),('sierpien',8),('wrzesien',9),('pazdziernik',10),('listoapd',11),('grudzien',12)


INSERT INTO DAYS VALUES ('poniedzialek',1),('wtorek',2),('sroda',3),('czwartek',4),
('piatek',5),('sobota',6),('niedziela',7)




INSERT INTO dim_time
    SELECT YEAR(ORDERDATE) * 10000 + month(ORDERDATE) * 100 + day(ORDERDATE),
        YEAR(ORDERDATE),
        (SELECT min(nazwa) FROM MONTHS WHERE liczba = month(ORDERDATE)),
        (SELECT min(nazwa) FROM DAYS WHERE liczba = datepart(dw, ORDERDATE)),
        day(ORDERDATE)
     FROM
     (
     SELECT DISTINCT ORDERDATE FROM AdventureWorks2014.Sales.SalesOrderHeader
     UNION
     SELECT DISTINCT ShipDate FROM AdventureWorks2014.Sales.SalesOrderHeader
     ) AS qrry



ALTER TABLE FACT_SALES
ADD CONSTRAINT FK_SHIPDATE FOREIGN KEY (ShipDate) REFERENCES DIM_TIME(PK_TIME);



ALTER TABLE FACT_SALES
ADD CONSTRAINT FK_ORDERDATE FOREIGN KEY (OrderDate) REFERENCES DIM_TIME(PK_TIME);








c)
UPDATE DIM_PRODUCT
SET Color = 'Unknown'
WHERE Color is null;

UPDATE DIM_PRODUCT
SET SubCategoryName = 'Unknown'
WHERE SubCategoryName is null;


d)
UPDATE DIM_SALESPERSON
SET CountryRegionCode = 000
WHERE CountryRegionCode is null;

UPDATE DIM_SALESPERSON
SET [Group] = 'Unknown'
WHERE [Group] is null;