Node.js & MySQL Homework Assignment

The purpose of this homework assignment is to practice working with Node.js and MySQL. This is a very simple command-line interface for interacting with the database using Node in an amazon-like way.

The program welcomes the user and asks whether they wish to order and item or exit the program. If they choose to place an order a list of items (which was pre-created using the zamazon.sql file). Each item has a stock quantity and price.

After the user enters the id of the item they want and the quantity they wish to order, the program verifies that there is sufficient stock to fill the order. If there is, the order is processed after displaying the price and updating the stock on hand. If there is not sufficient stock, the order is cancelled and the user is prompted to try again.

• Node.js
• MySQL
• Inquirer
• console.table
• Chalk
• Javascript

• After order is completed, ask user if they wish to make another purchase.
• Combine multiple purchases into one order.
• Add a "Manager" module that will allow:
  • View Products for Sale
  • View Low Inventory
  • Add to Inventory
  • Add New Product
• Add a "Supervisor module that will allow:
  • View Product Sales by Department
  • Create New Department