Data Management

Choose a business application area for developing the database. Describe the
purpose of the database.
We’ll definitely need improved wording here but the basic idea is we’re a new analytics team for superstore company and have been tasked with better
understanding out customers.
Trying to better understand our customers, their purchasing habits, and how we may better improve our service to them
Design the tables for this database. There may be 5 – 15 tables in the database.
Ensure that the tables are in “Normalized” form.
This is done as far as I can tell. It’s in the s22g_Team05_db schema
Map of the schema:
Populate the database with sample data (or part of real data if you can find any),
but it can be hypothetical data also.
Done
Develop a set of business questions (10 to 12). Write the business question and
the its purpose briefly. Formulate the SQL query to answer the question. These
queries must not be trivial. Most of the queries should use multiple tables and/or
multiple conditions. At least four queries must use aggregate functions and
“GROUP BY” functionality or use sub-query features.
Which product has the highest dollar value in sales?
select product_name, round(sum(sales) , 2)
from order_info
group by product_name
order by sum(sales) desc;
Which products have been purchased the most (i.e. have the highest quantity sold)?
select product_name, round(sum(quantity) , 2)
from order_info
group by product_name
order by sum(quantity) desc;
Which categories have the highest dollar value in sales?
select sum(a.sales), b.category
from order_info a
join category_info b
on a.product_id = b.product_id
group by b.category
order by sum(a.sales) desc;
Which products (by name) are the most profitable?
select sum(a.profit), b.product_name
from order_info a
join category_info b
on a.product_id = b.product_id
group by b.product_name
order by sum(a.profit) desc;

WHY CHOOSE US

NO MORE WORRIES

NO LATENESS!

PAPER FORMATTING

OUR GUARANTEES

NO LATENESS!