[SOLVED] Database Assignment 1-Supermarket System 

Supermarket System

You are asked to write a program that simulates a Supermarket system designed for administrative users only. As a project, it is designed to give you some practice on Databases and SQL using JAVA

When the admin runs the code, the computer first asks the user if he/she has an account. If so, the user must enter their email and password. Otherwise, the user must create an account using a SignUp form (Full Name, Email, and Password).

The Flow of The System:

After Authentication, the program starts by greeting the user and displaying this menu:

1. Display Statistics
2. List Products
3. Add New Product
4. Remove Product
5. Edit Product
6. Display Single Product
7. Change Currency
8. Exit

• ●  If the user chooses (1), the system should display some statistics to the user: Total Number of Products, Most expensive product, Least expensive product, and the number of products with quantity equal to 0.
• ●  If the user chooses (2), the program should ask the user if he/she wants to list all the products, the most expensive products (Top 5), or the least expensive products (Top 5). In any case, display the products sorted based on the price.
• ●  If the user chooses (3), the user shall be able to add a new product to the Database. The program prompts for product name, quantity and its price.
• ●  If the user chooses (4), the user shall be able to search and remove a

  specific product from the Database using its ID. A message will be displayed

  if the product is not found.

• ●  If the user chooses (5), the user shall be able to search for any product by ID

  and then update its information inside the Database. A message will be

  displayed if the product is not found.

• ●  If the user chooses (6), the system prompts for the name of the product or its

  ID and the system will display its information (quantity, price, etc) if found. A message will be displayed if the product is not found. (When the user searches by name, the system should display all occurrences ( using “Like”

keyword)

• ●  If the user chooses (7), the user shall be able to change the currency of the

  products in the Database (One currency for all the products). The system should display the current currency used in the system. Then, the user shall be able to enter the USD/LBP rate of his/her choice and the system will do the conversion for all the products in the DB.

• ●  If the user chooses (8), the program will terminate with a cute message.

  After each option, the menu is displayed again. The user can use the system multiple times.