PY
py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
CREATE TABLE DimProduct1(
Prod_ID INT NOT NULL PRIMARY KEY,
Prod_Name VARCHAR(255),
Prod_Quantity INT NOT NULL,
Prod_Cost NUMERIC(18,0) NOT NULL,
);
INSERT INTO DimProduct1(
Prod_ID,Prod_Name,Prod_Quantity,Prod_Cost)
VALUES(201,'Hammer',10,20.00);
INSERT INTO DimProduct1(
Prod_ID,Prod_Name,Prod_Quantity,Prod_Cost)
VALUES(202,'Nails',20,5.00);
INSERT INTO DimProduct1(
Prod_ID,Prod_Name,Prod_Quantity,Prod_Cost)
VALUES (203,'Lumber',50,5.00);
INSERT INTO DimProduct1(
Prod_ID,Prod_Name,Prod_Quantity,Prod_Cost)
VALUES(204,'Premium Paintz',10,25.00)
CREATE TABLE DimSupplier(
Sup_ID INT NOT NULL PRIMARY KEY,
Prod_ID INT NOT NULL REFERENCES DimProduct1(Prod_ID),
SupAmountDue NUMERIC(18,0) NOT NULL,
Sup_DueDate DATE NOT NULL,
Items_Ordered INT NOT NULL,
);
INSERT INTO DimSupplier(
Sup_ID,Prod_ID,SupAmountDue,Sup_DueDate,Items_Ordered)
Enter to Rename, Shift+Enter to Preview
OUTPUT
Run