- When opened, a display of all products showing the sku, product name, department name, price, and quantity of each item. Beneath the display, the user is prompted whether or not they want to buy a product
- If the user decides to buy a product, they select the product from the list of products.
- Once a product is selected, the user decides the quantity they want and then the total is displayed, which also updates the quantity in the original table.
- When opening the bamazonManager file, the user is presented with the following list of options:
-
Like the bamazonCustomer file, if the user selects "View Products for Sale", they see the same table listing all products and their subsequent details.
-
Selecting "View Low Inventory" shows the user all products that have less than 5 items remaining.
- When the user selects "Add to Inventory", the user selects the product from a list, inputs the quantity they want to add, and is presented a display informing them that the number they input were successfully added to the database.
- If the user selects "Add New Product", they will be prompted to add the name of the product, the name of the department, and the price. Once those are entered, a string appears telling the user the product was successfully added.
- When the user accesses the bamazonSupervisor file, they are presented with two options:
- "View Product Sales by Department"
- When selected, the subsequent table shows the department ID, department name, over head costs, product sales, and total cost.
- "Create New Department"
- When selected, the user is prompted to add a new department, which updates the options for the bamazonManager file as well.