An Amazon-like storefront with the MySQL. The app will take in orders from customers and deplete stock from the store’s inventory. This app will also track product sales across the store’s departments and then provide a summary of the highest-grossing departments in the store.
Starting command line actions: Input into the command line to enter the application
Running this applicaiton will propt the user to first enter the *bamazon store, and then displays all the items in the store within the command line (aka, table details from the mySQL database). The the following happens in order:
The user is propmted which item they want to buy and what quantity.
The request is then processed if enough quantiy of that item is available, otherwise the user is notoified that there is not enough quantity and to update their order.
After an order is processed, the total price for the item and quantity is displayed to the user and the database it updated with the new stock amount.
Lastly, the user is prompted if they would like to make another order, or exit the store.
Running this applicaiton will propmt the user to select an action:
This option will display all the products in the store with the following info in the terminal:
This option will display items in the terminal that have an invetory less than 5.
This option allows the user to add more inventory of the product that updates the database.
This option will allow the user to add a new product to the database of products so that it will be a part of the store.