.01)
Make SQL Database and populate it with item_id,product_name department_name, price, stock_quantity .02) Then create a Node application called bamazonCustomer.js. Running this application will first display all of the items available for sale. Include the ids, names, and prices of products for sale.
The app should then prompt users with two messages.
The first should ask them the ID of the product they would like to buy. The second message should ask how many units of the product they would like to buy. .03 Once the customer has placed the order, your application should check if your store has enough of the product to meet the customer's request. If not, the app should log a phrase like Insufficient quantity!, and then prevent the order from going through. .04 Take the quantity of users requested item and subtract from database, after which display the users total.
.05
Create a new Node application called bamazonManager.js Running this application will: List a set of menu options: View Products for Sale View Low Inventory Add to Inventory Add New Product
.06
If a manager selects View Products for Sale, the app should list every available item: the item IDs, names, prices, and quantities.
If a manager selects View Low Inventory, then it should list all items with an inventory count lower than one thousand.