Database Management Systems -Solved

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. 
N.B: Use good programming habits. Good Luck *.*