[go: up one dir, main page]
Scribd
Upload
29 views1 page

Sales Database

Uploaded by

osesayjr
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
29 views1 page

Sales Database

Uploaded by

osesayjr
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

SALES DATABASE

Customers Table:

Customer ID Customer Name Customer Phone Customer Address


1 Musa Kamara +23276111111 123 Kingharman Road
2 Fatmata Jalloh +23276222222 456 Wilkinson Road
3 Mohamed Bangura +23276333333 789 Kissy Road
4 Aminata Koroma +23276444444 101 Aberdeen Road
5 Ibrahim Sesay +23276555555 202 Wilkinson Road

Employee Table:

Employee Employee Name Phone Address


ID
1 Alpha Sesay +23276777777 5 Peter Lane
2 Alimamy Koroma +23276888888 17 Cole Street
3 Mariama Kargbo +23276999999 2 Circular Road
4 Foday Conteh +23276101010 6 Jones Street
5 Haja Kamara +23276202020 8 Campbell Street

Product Table:

Product Product Name Quantity in Stock Unit Price


ID
1 Laptop 10 1000
2 HP Mouse 50 200
3 Keyboard 30 500
4 Monitor 20 200
5 Printer 15 150

Sales Table:

SaleI
CustomerID EmployeeID ProductID UnitPrice Quantity TotalAmount SaleDate
D
1 3 1 2 1000 1 1000 8/1/2024
2 3 1 4 20 2 40 8/2/2024
3 2 4 1 50 1 50 8/3/2024
4 2 4 3 200 2 400 8/4/2024
5 8 6 5 150 1 150 8/5/2024
6 8 6 6 1000 1 1000 8/6/2024
7 9 7 7 100 1 100 8/7/2024
8 9 7 9 20 3 60 8/8/2024
9 10 2 8 200 1 200 8/9/2024
10 10 2 10 50 2 100 8/10/2024

You might also like