[SOLVED] Database Management Systems Final Lab Exam

Description

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.*