product ID | product name | quantity | quantity |
---|---|---|---|
P01 | Processor | 50 | 8500 |
P02 | Hard Disk | 50 | 4500 |
P03 | RAM | 50 | 2500 |
P04 | Monitor | 50 | 12000 |
P05 | Printer | 50 | 5600 |
P05 | Key board | 50 | 600 |
Customer ID | Customer Name | Address |
---|---|---|
C001 | Saman Kumara | Galle Rd, Colombo 3 |
C002 | Gamini Silva | No 23,Nugegoda |
C003 | Samantha Perera | NAwela Road,Nugegoda |
Sales ID | Customer ID | Product ID | Quantity |
---|---|---|---|
S01 | C001 | P01 | 10 |
S02 | C001 | P02 | 5 |
S03 | C001 | P03 | 3 |
S04 | C002 | P01 | 2 |