Question
Slainte has brought you in to help determine potential areas for sales growth in the next year. Additionally, management has noticed that the company's margins
Slainte has brought you in to help determine potential areas for sales growth in the next year. Additionally, management has noticed that the company's margins aren't as high as they had budgeted and would like to help identify some areas where they could improve their pricing, marketing, or strategy. They would like to know how many of each product were sold.
Identify the data attributes and tables needed to answer the question.
Names of tables: FGI Product, Customer, Sales subset
Attributes: Product Code, Product Description, Quantity sold, sales price, sales order id, customer id, customer st, customer address, customer city, customer zip, business name, sales order date, employee id.
Please let me know which tables and 5 attributes needed to answer the question. Thanks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started