🦷 Dental Clinic Management System – SQL Database

📌 Overview

This project is a Dental Clinic Management System built using MySQL. It simulates a real-world clinic environment by organizing and managing data related to rooms, staff, patients, appointments, and medical records.

The system is designed to help with:

• Managing clinic rooms by department and availability
• Registering dentists and nurses
• Handling patient records and appointments
• Tracking administrative staff
• Storing and retrieving patient medical history

---

🗃️ Database Schema

The database contains the following tables:

• Room
• Dentist
• Nurse
• Patient
• Administrative_Staff
• Appointment
• Patient_Medical_History

All tables are properly structured using:

• Primary Keys
• Foreign Keys
• Relationships between entities
• Realistic and normalized data types

---

📊 Tables Description

🏥 Room

Stores clinic room details:

• Room ID
• Department
• Availability status

👨‍⚕️ Dentist

Contains dentist information:

• Dentist ID
• Name
• Department
• Assigned room (if applicable)

👩‍⚕️ Nurse

Stores nurse details:

• Nurse ID
• Name
• Assigned department

🧑‍💼 Administrative_Staff

Manages admin staff records:

• Staff ID
• Name
• Role

🧑 Patient

Stores patient information:

• Patient ID
• Name
• Contact details

📅 Appointment

Handles appointment scheduling:

• Appointment ID
• Patient ID (FK)
• Dentist ID (FK)
• Date & Time

📋 Patient_Medical_History

Stores medical records:

• Record ID
• Patient ID (FK)
• Diagnosis
• Treatment details

---

▶️ How to Use

1️⃣ Create the Database

CREATE DATABASE teast;
USE teast;

2️⃣ Create Tables

Run the provided CREATE TABLE SQL scripts to set up the schema.

3️⃣ Insert Sample Data

Execute the INSERT INTO statements to populate the database with initial data.

4️⃣ Run Queries

You can now:

• Retrieve data using SELECT
• Update records using UPDATE
• Manage relationships using JOIN

---

🧪 Sample Data

The database includes:

• 25 rooms across different departments
• 25 dentists linked to departments
• 25 nurses and 25 administrative staff
• Sample patient records
• Sample appointments
• Sample medical history entries

(Data can be expanded as needed.)

---

🚀 Future Improvements

• Add billing and payment system
• Implement user authentication
• Build a frontend dashboard
• Add reporting and analytics

---

👩‍💻 Author

Menna Kamel

---

📄 License

This project is for educational purposes and can be modified or extended freely.