BambiZon

Command line application to demonstrate MySQL, Node.js & a fantasy shopping world.
Bootcamp Assignment 10/28/2018 - Node.js & MySQL

About Us

BambiZon is an e-commerce company founded in 2018 as a niche marketplace to supply hard-to-find items to Hollywood's most elite and ageless cartoon characters. Since it's humble beginnings when it had only 2 products (snow mittens sized perfectly for little dancing hooves, and sustainably sourced rain forest cotton-tail shampoo), BambiZon has grown to a multi-baZillion buZiness and is the world's largest online imaginary retailer. You can find the BambiZon marketplace at https://github.com/SueJStevens/bambizon_v1. We accept all forms of virtual currency including $Disney$Dollars, $Monopoly$Money and $bit$Coin. Come $hop with us today!

App Features

Customer View

1. All items available for sale will populate the view when the customer runs the app.
2. App will prompt the user with 2 messages so the user can purchase items
3. App will check the store to confirm there is quantity to fulfill order Screen Shot for insufficient quantity
4. If sufficient quantity, order is fulfilled. Database quantity and sales fields are updated and app gives user total cost of their purchase Screen Shot from MySQL Workbench of state of data before purchase Screen Shot of Customer's total cost Screen shot of new quantity and total sales from MySQL Workbench after purchase

Manager View

Manager View has a menu list to choose from:

1. View Products for Sale Lists every available item

2. View Low Inventory List items with an inventory count lower than 5

3. Add to Inventory Displays prompts so manager can add more items

4. Add New Product Displays prompts so manager can add a completely new product

Supervisor View

Superviser View has a menu list to choose from:

1. View Product Sales by Department Screen Shot of Summerized Table

2. Create New Department