Hospital Care Database & Interface System

A full-stack database application combining a robust relational backend with a responsive desktop frontend interface.

Database Architecture & UI

Tech Stack & Tools Used

• Frontend Interface: Visual Studio 2026 Community Edition (C# / .NET)
• Backend Database: MySQL Server
• Database Management: MySQL Workbench

Key Features

• Relational Database Design: Fully structured relational tables managing connected records securely.
• CRUD Operations: Complete frontend interface to Create, Read, Update, and Delete records directly from the database.
• Data Integrity: Implemented primary keys, foreign key constraints, and structured queries to prevent data anomalies.

How to Run and Set Up the Project

1. Database Setup

1. Open MySQL Workbench and connect to your local instance.
2. Open and execute the database_setup.sql file included in this repository to automatically generate the database schema, tables, and relationships.

2. Frontend Interface Setup

1. Open Visual Studio.
2. Open the solution file (.sln) located inside the project folder.
3. Check your database connection string in the code (e.g., App.config or database connection class) to ensure it matches your local MySQL username and password.
4. Press Start to run the application interface.