🛒 SampathFoodCity - Academic Database Project

📝 Overview

SampathFoodCity is an academic offline food city management system developed to demonstrate advanced concepts in database design and development. The main focus of this project is building a well-structured relational database using Microsoft SQL Server Management Studio (SSMS) and integrating it into a fully functional desktop-based application using Java.

This project simulates the internal operations of a food retail store, managing inventory, sales, and customers through a user-friendly interface.

✨ Key Features

• 📊 Structured relational database design with normalized tables.
• 🔐 Secure and efficient Java + JDBC connectivity with SQL Server.
• 💻 Offline desktop application—no internet required.
• ⚙️ Supports multiple modules including:
  • 📦 Product Management
  • 📈 Inventory Tracking
  • 💰 Sales Management
  • 🧾 Billing and Reporting

🧰 Technologies Used

• 🗄️ Backend Database: Microsoft SQL Server Management Studio (SSMS)
• ☕ Programming Language: Java
• 🔗 Database Connectivity: JDBC (Java Database Connectivity)
• 🛠️ IDE: NetBeans

🚀 Future Improvements

• 🌐 Add online/cloud database support for multi-location access
• 📱 Develop a mobile version using JavaFX or Android
• 🧠 Integrate basic AI for sales prediction and smart stock management
• 📤 Add export options (PDF/Excel) for sales and inventory reports
• 👥 Introduce multi-user role management and login security features
• 🖥️ Improve the user interface with modern UI libraries (e.g., JavaFX)

---