MediTrack — Hospital Management System (DBMS Project)

A simple hospital management system covering patients, doctors, nurses, rooms, consultations, billing, and test reports. Built as a DBMS course project — CRUD operations only, no advanced database features.

Tech Stack

• Frontend: React.js (Vite, React Router, Tailwind/CSS)
• Backend: Node.js with Express
• Connectivity: mysql2 (Node.js MySQL driver)
• Database: MySQL

Team & Ownership

Role	Folder	Owner
Frontend/UI	src/frontend/	Srikanth
Backend APIs	src/backend/	(TBD)
Connectivity	src/connectivity/	(TBD)
Shared	database/, docs/	Whole team

See RULES.md for coding conventions and folder ownership rules, and requirements/requirements.md for the full functional requirements list.

Folder Structure

MediTrack/
├── README.md
├── RULES.md
├── requirements/
│   └── requirements.md
├── database/
│   └── schema.sql
├── src/
│   ├── frontend/       # React app (package.json, Vite config, /src)
│   ├── backend/        # Express server & API routes (package.json, server.js)
│   └── connectivity/   # Database connection pool & query execution
└── docs/               # ER diagram, normalization notes, screenshots

Setup

1. Database Initialization

• Install MySQL on your system.
• Run the database/schema.sql file in your MySQL environment to create the tables, relationships, and constraints.

2. Frontend Setup (React/Vite)

• Open a terminal and navigate to the frontend folder: cd src/frontend
• Install dependencies: npm install
• Start the development server: npm run dev
• The UI will be available at http://localhost:5173.

3. Backend & Connectivity Setup (Node/Express)

• Open a second terminal and navigate to the backend folder: cd src/backend
• Install dependencies: npm install
• Update your database credentials (username/password) inside the connectivity layer.
• Start the API server: node server.js
• The backend will run on http://localhost:3000.

Status

• ER diagram
• Relational mapping
• Normalization to BCNF
• Frontend UI (React screens & mock state)
• Schema implemented in MySQL
• Connectivity layer (DB Pool)
• Backend CRUD logic (Express API)
• Integration & testing