Database Essentials for Business - Customer Data Analysis and Queries

This assignment focuses on Database Essentials for Business, analyzing customer data and demonstrating the use of SQL queries. The solution explores how customer income and order quantities can be used to improve business strategies, including customer satisfaction and efficient manufacturing processes. The assignment provides examples of queries to extract relevant customer information, such as customer addresses and city, for delivery scheduling and customer relationship management. It emphasizes the importance of customer data in making informed business decisions and includes references to relevant literature on customer satisfaction and relationship management. This assignment is designed to help students understand the practical applications of database concepts in a business context and is contributed by a student to be published on Desklib.

Running head: DATABASE ESSENTIALS FOR BUSINESS
Database Essentials for Business
Name of Student
Name of university
Author Note

1DATABASE ESSENTIALS FOR BUSINESS
Business Improvement using Management System
The woodcraft database stores its customer details along with their involvement with the
woodcraft company. In a business organisation, customer and their purchases have direct impact
on the sales of the company (Pearson, 2016). First, the query and the column field that would be
better to analyse, are the customer’s income, their quantity of orders and their address. Also, the
number of orders is much more than others whose income is more than $50000. It is shown in
the Figure 1 that what columns can be selected and how. If the company observes the regular
customer’s purchases on daily basis and the product are ready on time before getting any order
placed then the time consumption for the manufacturing can be reduced along with the
customer’s personal time. Also, the preferred column clearly specifies the customer’s name in
the table. This will increase the customer satisfaction level towards the company (Hill &
Alexander, 2017). On another hand, the tables that could help will be the order records for
keeping the company related records apart from the customer’s personal detail so that the table
only focuses on the one body at a time. Second, the addresses of the customer play the vital role
here. The number of customers who are having their address in same city can be picked. This
query will have customer’s address, city and their name along with the id. Hence the company
can allocate and plan the delivery schedule according to the customer’s location. Figure 2 shows
the selection of customer and their city.

2DATABASE ESSENTIALS FOR BUSINESS
Figure 1: Query 1
Source: created by author

3DATABASE ESSENTIALS FOR BUSINESS
Figure 2: Query 2
Source: created by author

4DATABASE ESSENTIALS FOR BUSINESS
References
Hill, N., & Alexander, J. (2017). The handbook of customer satisfaction and loyalty
measurement. Routledge.
Pearson, S. (2016). Building brands directly: creating business value from customer
relationships. Springer.