CREATE TABLE Employee (id int primary key ,name varchar(50) );
INSERT INTO Employee (id,name) values (1,'Michael Suyama');
INSERT INTO Employee (id,name) values (2,'Nancy Davolio');


CREATE TABLE Product (id int primary key , code char(3), name varchar(50), price  decimal );
INSERT INTO Product (id,code,name,price) values (1,'EO1','Momogi',500);
INSERT INTO Product (id,code,name,price) values (2,'EO2','Pepsi',5000);
INSERT INTO Product (id,code,name,price) values (3,'EO3','Ayam',50000);

CREATE TABLE Sale (id int primary key, employeeId int ,foreign key (employeeID) references Employee(id));
INSERT INTO Sale(id, employeeId) values (1,1);


CREATE TABLE SaleLineItem (quantity int, price decimal,saleId int, productId int, foreign key(saleId) references Sale(id), foreign key (productId) references Product(id) );
INSERT INTO SaleLineItem(quantity, price,saleId , productId) values (2,500,1,1);
INSERT INTO SaleLineItem(quantity, price,saleId , productId) values (1,5000,1,2);