use blankey
DROP TABLE IF EXISTS Orders_Fact
DROP TABLE IF EXISTS Employee
DROP TABLE IF EXISTS Time
DROP TABLE IF EXISTS Product
DROP TABLE IF EXISTS Customer
CREATE TABLE Employee (
Id INT IDENTITY(1,1) PRIMARY KEY,
Last_Name VARCHAR(50),
First_Name VARCHAR(50),
State_Province VARCHAR(50),
)
CREATE TABLE Time (
Id INT IDENTITY(1,1) PRIMARY KEY,
Year INT,
Quarter INT,
Month INT,
Day INT,
)
CREATE TABLE Product (
Id INT IDENTITY(1,1) PRIMARY KEY,
Name VARCHAR(50),
Category VARCHAR(50),
Price FLOAT
)
CREATE TABLE Customer (
Id INT IDENTITY(1,1) PRIMARY KEY,
CompanyName VARCHAR(50),
)
CREATE TABLE Orders_Fact (
Id INT IDENTITY(1,1) PRIMARY KEY,
ProductId INT FOREIGN KEY REFERENCES Product(Id),
EmployeeId INT FOREIGN KEY REFERENCES Employee(Id),
TimeId INT FOREIGN KEY REFERENCES Time(Id),
CustomerId INT FOREIGN KEY REFERENCES Customer(Id),
TotalPrice FLOAT,
Quantity INT
)