EDA and preprocessing
In the ShopSphere database, EDA and preprocessing involve simple but important steps to understand and clean the data. First, EDA helps us see patterns and important details in the data. This is done using simple statistics and graphs to look at things such as how many orders there are, where customers live, and what they buy.
Database schema
The following figure shows the relation diagram between the tables. These tables show how the application will process the business logic:
Figure 3.1 – Design of the database model
As we can see, the database comprises several tables. In the following sections, we will analyze each table individually and perform preprocessing to prevent extra space consumption.
MySQL
This section will cover the steps you need to follow to use a MySQL database locally. We will start by installing it on a virtual machine, where you can use your local host, Windows, or macOS to get going for this...
