This repository contains the implementation of a Departmental Store Database Management System, developed as an academic project to demonstrate practical knowledge of Database Management Systems (DBMS) using both relational and NoSQL databases.
The project is implemented in two versions:
- A Standalone Desktop Application using Microsoft Access
- A Web-Based Application using MongoDB
The Departmental Store Database Management System is designed to manage and organize the day-to-day operations of a departmental store. The system supports essential business functions such as:
- Staff management
- Sales tracking
- Lease management
- Tenant and utilities management
- Repair services
- Promotions
The project is implemented in two versions to explore different database paradigms:
- Standalone Desktop Application using a relational database
- Web-Based Application using a NoSQL database
- C# / .NET
- Microsoft Access
- Visual Studio 2022
- Secure login system
- Centralized home dashboard
- Dedicated forms for each business module
- Full CRUD operations (Create, Read, Update, Delete)
- Simple and user-friendly interface
- C# / .NET
- MongoDB
- MongoDB.Driver (NuGet Package)
- Visual Studio 2022
- Web-based interface for accessibility
- MongoDB-backed data storage
- Flexible, schema-less data handling
- Similar functional modules as the desktop application
- CRUD operations on MongoDB collections
Username: Admin Password: 0000
This project was developed as part of a Enterprise Database Management Systems course to:
- Apply DBMS concepts in a real-world scenario
- Compare relational and NoSQL database approaches
- Design functional, data-driven applications
- Strengthen practical software development skills