A retail store wants to understand their customer behavior using sales data.
Data available- Customer: Customer demographics, Product: Product category and sub-category information, Transaction: Customer transaction details
Refer Entity relationship diagram to understand how the tables are related to each other.