💐 Family Reunion Database: A SQL Story

🧠 Overview

This project is a structured SQL Server database designed to manage and organize family reunions — from facilities and members to scheduled events and attendance responses.
It was created as my final SQL assignment, showcasing my understanding of:

• Database creation
• Table relationships
• Constraints
• Transactions and error handling

---

🗂️ Database Details

Database Name: Assignment06HTharhan

🏠 Tables

1. Facility

   • Stores information about available reunion venues.

2. FamilyMembers

   • Tracks each family member’s details (name, email, status, etc.).

3. ScheduledReunion

   • Holds data for planned reunions — including date, time, location, and costs.

4. ReunionResponses

   • Records RSVPs and payment information from family members.

---

🔗 Relationships

• Each ScheduledReunion is linked to one Facility.
• Each ReunionResponse is tied to one FamilyMember and one ScheduledReunion.

All foreign keys are validated with existence checks before creation to ensure database integrity.

---

⚙️ Features

• ✅ Transaction-based creation with rollback on error
• 🧩 Primary and foreign key constraints
• 🧮 Improved decimal precision for monetary fields
• 🧍‍♀️ Nullable middle names for flexibility
• 💬 User-friendly success/error messages

---

🧱 How to Run

1. Open Microsoft SQL Server Management Studio (SSMS).
2. Run the script Assignment06HTharhan.sql.
3. The database and tables will be created automatically!
4. Look for the success message:

---

🩵 Author

Heba Tharhan
🎓 Final SQL Project | 2025
☕ "Built with care, one transaction at a time."

---

🌷 License

This project is for educational purposes only.
Feel free to explore and modify it for learning!