1
Sale Order ID: 9981
Created by: Mr A
Product Id Product Name Quantity
Cocacola
Sale Price
2
10
2
Pepsi
1
8
3
Fanta
1
9.5
4
5
Sting
Monster
Save
o When user clicks [Save] button. New Sale Order will be added to [SaleOrder ] table such that [created_by] will be the id of the logged user, and [date] is current date (1 point). The corresponding sale order lines will be added to [SaleOrderProduct] table (3 points).
Sale Order ID: 9981
Created by: Mr A
Product Id Product Name
Quantity
1
Cocacola
2
2
Pepsi
1
3
Fanta
1
14
Sting
5
Monster
Save
Sale Price
10
8
9.5
poid
pid
quantity
purchaseprice
1
9981 1
2
10
id
created_by
date
2
9981 2 1
8
1
9981
mra
2023-04-18
3
9981 3 1
9.5
[SaleOrder] Table
[SaleOrderProduct] Table
