Activity 7.01 – building a database application with Node.js

You work for a marketing company called Marketing Our Thing. You have been asked by Fred, the Marketing Head, to create a small database with two tables to store the details of its customers and the purchases they have made. Fred has provided you with details of what he wants in a Requirements.txt document. You are been asked to create two scripts that will run in Node.js – one to create the database and another to create the tables and fields. Both scripts should take advantage of the mysqlconnection.js file to create a data connection.

The following are the requirements:

• Database Name: MOTdatabase
• Table Name: Customers
• Table Definition:

Figure 7.29 – The Customers table

• Table Name: CustomerPurchases
• Table Definition:

Figure 7.30 – The CustomerPurchases table

Note

You can find the Requirements.txt file at...