An interactive shopping node app where MySQL and Node.JS are used to allow users to purchase items as a customer. This application implements a command line based storefront using the npm inquirer package and the MySQL database together with the npm mysql package.
The customer interface allows the user to view the current inventory of store items: item IDs, descriptions, department in which the item is located and price. The user is then able to purchase one of the existing items by entering the item name and the desired quantity. If the selected quantity is currently in stock, the user’s order is fulfilled and the stock quantities are updated