Activity 8.02 – designing a customer database

In Activity 5.01 – building a database application with Node.js, you created a database named MOTDatabase, which contained a Customer table and a CustomerPurchases table. The company has since started to acquire customers and sales, and as such, they require data to be added to these existing tables.

Additionally, the company would like an ODBC connection available for the database. You can assume that the database exists on localhost, so the ODBC IP will be 127.0.0.1.

Currently, the company has the following customers that they would like inserted into the customers table:

Figure 8.31: The data to be inserted into the customers table

The company currently has the following purchases that it would like inserted into the CustomerPurchases table:

Figure 8.32: The items to be inserted into the CustomerPurchases table

To do this, you will need to complete the following steps...