Answer To: In addition, submit the star schema and the DDL to create the Star schema for the data warehouse....
Neha answered on Feb 06 2021
75443 - star schema/diagram.png
75443 - star schema/report.docx
Star Schema Diagram
Database Schema
Create table Customer (
CustomerId int primary key,
Name varchar(50),
Address varchar(100),
PhoneNumber varchar(10),
EmailAddress varchar(50),
Title varchar(5)
);
Create table Employee (
EmpId int primary key,
Name varchar(50),
Address varchar(100),
PhoneNumber varchar(10),
EmailAddress varchar(50),
Salary int,
Profile varchar(20)
);
Create table Product(
ProdId int primary key,
ItemName varchar(30),
Price double,
Size int,
Weight float
);
Create table Time(
TimeId int primary key,
OrderDate date,
OrderTime time);
Create Table FactTable(
FactId int primary key,
CustomerId int,
ProductId int,
TimeId int,
EmployeeId int,
Quantity int,
TotalPrice int,
Foreign key (CustomerId) references Customer(CustomerId),
Foreign key (ProductId) references Product(ProdId),
Foreign key (TimeId) references Time(TimeId),
Foreign key (EmployeeId) references Employee(EmpId)
);
To design the star schema of any data warehouse it is important to...