Scribd
Upload
3 views2 pages

Customer Transactions and Products Data

Uploaded by

priiincema
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
3 views2 pages

Customer Transactions and Products Data

Uploaded by

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

Customers Table

customer_id name loyalty_points

101 Shehu Salihu 150


201 Job Timothy 200
305 Agnes Pam 300
405 Esther James 120
509 Larry Adams 250

Transactions Table

transaction_id customer_id amount_spent

1 101 100
2 201 200
3 305 300
4 405 400
5 509 150
6 305 500

Products Table

product_id product_name price

102 Laptop 200000


201 Smartphone 500000
203 Blender 120000
104 Sofa 450000
107 Desk Lamp 350000
registration_date age

5/15/2019 35
6/20/2020 42
8/10/2018 29
1/5/2022 50
10/12/2021 32

transaction_date

5/10/2023
5/11/2023
5/12/2023
5/13/2023
5/14/2023
5/15/2023

category

Electronics
Electronics
Home Appliance
Furniture
Furniture

You might also like