create table Employee_Dimension
(EmployeeID char(10) ,
EmployeeName varchar(30),
EmployeeSurname char(30),
EmployeeAddress varchar(30),
EmployeeNumber int,
ShopID char(10),
constraint pk_Employee_Dimension primary key (EmployeeID),
constraint fk_Employee_Dimension foreign key (ShopID)
references dbo.Shop_dimension(ShopID));