📱 MobileTechHub - Retail Shop Database & Application

MobileTechHub is a simple database-driven desktop application designed for a retail mobile phone shop based in Colombo, Sri Lanka. It allows users to manage customers, products, sales, returns, and repairs through a Python GUI and a Microsoft SQL Server database.

---

🧰 Tech Stack

• Frontend: Python Tkinter
• Backend: Microsoft SQL Server
• Connector: pyodbc for database communication
• IDE: VS Code / SSMS / Python 3.x

---

📁 Project Structure

MobileTechHub-ADBMS-System/
├── app/
│   ├── **init**.py
│   ├── gui.py             # Main GUI application
│   ├── customer.py        # Customer operations
│   ├── product.py         # Product operations
│   └── ...                # Add more modules (sales, repairs, etc.)
│
├── database/
│   ├── **init**.py
│   └── connection.py      # SQL Server connection logic
│
├── docs/
│   ├── ER_Diagram.svg     # Exported ER/EER diagram
│   ├── Mapping.svg        # Step-by-step normalization
│   └── Project_report.pdf
│
├── README.md              # Project documentation
└── requirements.txt       # Python dependencies (optional)

---

🔌 Setup Instructions

1. 🗄️ SQL Server Setup

• Create the database in SQL Server (e.g., MobileTechHubDB).
• Use SQL scripts to create tables, constraints, triggers, views, etc.

2. ⚙️ Python Environment

pip install pyodbc

3. 🔑 Configure Database Connection

In database/connection.py, update your connection string:

conn_str = (
    "Driver={ODBC Driver 17 for SQL Server};"
    "Server=localhost\\SQLEXPRESS;"  # or your actual SQL Server name
    "Database=MobileTechHubDB;"
    "Trusted_Connection=yes;"
)

4. 🚀 Run the App

From the root directory:

python -m app.gui

---

🧪 Features

• ✅ View and add customer records
• ✅ View and add product records
• ✅ Modular backend with clean database access logic
• 🛠️ Extendable to sales, invoices, returns, and repairs
• 📊 Business intelligence and data mining support (planned)

---

📝 Assignment Sections Covered

• Section 1: ER Diagram, Normalization, Relational Mapping
• Section 2: SQL Table Creation, Data Insertion
• Section 3: Triggers, Views, UDFs, Stored Procedures
• Section 4: Application functionality + Business Intelligence

---

📌 TODO

• Add GUI modules for returns, repairs
• Implement search and filters
• Add exception handling and logging

---

This project is for academic and educational purposes.