This project is an Integrated Multi-Branch Healthcare and Pharmaceutical Management System designed to handle complex database requirements for a healthcare provider operating across multiple locations. It integrates patient management, human resources, pharmaceutical inventory, and branch operations.
- Branch & Department Management: Manages multiple hospitals/clinics and their internal departments.
- Human Resources (HR): Tracks doctors, nurses, and administrative staff.
- Patient Management: Handles patient registration, appointments, and medical records.
- Pharmaceutical Management: Manages medicine inventory, stock levels across branches, and sales.
- Billing & Pharmacy Sales: Integrated billing for medical services and pharmacy purchases.
- Database: PostgreSQL (or standard SQL)
- Normalization: Up to 3NF
- Sample Data: 30-50 records per major entity
- Complexity: 10+ complex SQL queries including joins, aggregations, and subqueries.
student_tutorial.py: A beginner-friendly script showing basic Python+SQLite interaction.docs/student_guide.md: A gentle introduction to understanding the database logic.docs/: Design documents, ER diagrams, and project report.sql/: SQL scripts for schema creation and data insertion.queries/: SQL scripts for reporting and data analysis.