Skip to content

A DBMS-powered application for managing grocery store operations with ACID-compliant transaction handling. Supports customer ordering, profile management, and detailed admin controls like stock refill and sales analysis. Ensures data integrity, secure login, and smooth user experience for both customers and administrators.

Notifications You must be signed in to change notification settings

A-WASIF/GroceryStore_DBMS

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Project Overview

The Grocery Management Application utilizes Database Management Systems (DBMS) and ACID properties to ensure data integrity and transaction reliability. ACID principles, including Atomicity, Consistency, Isolation, and Durability, govern transactional behavior, guaranteeing data consistency and reliability. Conflicting transactions arise when multiple transactions modify the same data concurrently, while non-conflicting transactions operate independently. Commits finalize transactions, making changes permanent, while rollbacks reverse transaction effects in case of failure. This project exemplifies efficient transaction management, maintaining a seamless experience for customers and administrators in managing grocery store operations with reliability and integrity.

User Guide for Grocery Management Application

Welcome to the user guide for the Grocery Management Application. This guide will help you navigate through the functionalities available in the application.

Initial Options

When you start the application, you will be presented with the following options:

  1. Exit: Choose this option to exit the application.
  2. Login as Customer: Use this option if you are a registered customer and want to access customer-specific functionalities.
  3. Login as Admin: Select this option if you are an administrator and want access to admin-specific features.

Customer Menu

If you choose to login as a customer, you will have access to the following functionalities:

  1. Ordering: Place an order for products available in the store.
  2. Customer Analysis: View your profile, payment history, and product history.
  3. Updating Customer Profile: Update your personal information like name, address, phone number, etc.

Admin Menu

If you choose to login as an admin, you will have access to the following functionalities:

  1. Add Delivery Assistant: Add a new delivery assistant to the system.
  2. Add Store: Add a new store to the system.
  3. Store Analysis: View available stores or see stores with maximum profit.
  4. Product Analysis: View available products, most sold products, or see feedback for a specific product.
  5. Refill Stock: Refill stock for products when the quantity falls below a certain threshold.

Additional Information

  • To log in, you need to provide your registered email ID and password. If you enter incorrect credentials, you will be prompted to try again. After three failed attempts, you will be notified about exceeding the maximum login attempts for your email ID.
  • You can exit the application at any time by selecting the "Exit" option from the main menu.
  • Password must be at least 8 characters long.
  • When placing an order, you can choose from various payment methods such as Cash, Debit Card, Credit Card, or Pay Pal.
  • After placing an order, you will receive confirmation along with details about the delivery assistant assigned and the store from which the order will be fulfilled.
  • You can submit feedback for a product after receiving your order.

Contributors

Subham Maurya (2022510) Wasif Ali (2022580)

About

A DBMS-powered application for managing grocery store operations with ACID-compliant transaction handling. Supports customer ordering, profile management, and detailed admin controls like stock refill and sales analysis. Ensures data integrity, secure login, and smooth user experience for both customers and administrators.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published