CityHospital Appointment System

An End-to-End Web-Based Hospital Appointment Management Platform

---

1. Project Overview

CityHospital Appointment System is a web-based healthcare platform designed to simplify appointment management for patients and hospital administrators.

The system allows patients to register, log in, view available doctors and appointment slots, book appointments, manage appointment history, and cancel appointments. Administrators can manage doctors, create appointment slots, monitor bookings, and manage appointment schedules.

The project combines a responsive frontend with a Node.js/Express backend and MySQL database integration.

---

2. Problem Statement

Managing hospital appointments manually can lead to scheduling conflicts, limited visibility of available slots, and difficulty tracking patient appointments.

CityHospital provides a centralized digital platform that helps:

1. Patients — Find doctors, select available slots, and manage appointments.
2. Administrators — Manage doctors, schedules, slots, and bookings.
3. Backend Services — Handle authentication, appointment operations, and database communication.

---

3. System Architecture

+---------------------------------------------------------------+
| FRONTEND                                                      |
| HTML + CSS + JavaScript                                      |
| Patient Dashboard + Admin Dashboard                           |
| Handles authentication UI, doctors, slots and appointments   |
+---------------------------------------------------------------+
                              |
                              v
+---------------------------------------------------------------+
| BACKEND API                                                   |
| Node.js + Express.js                                          |
| Authentication + Appointment APIs + Admin Operations          |
+---------------------------------------------------------------+
                              |
                              v
+---------------------------------------------------------------+
| DATABASE                                                      |
| MySQL                                                         |
| Users + Doctors + Slots + Bookings                            |
+---------------------------------------------------------------+