Sunshine Haven Orphanage Management System

Overview

The Sunshine Haven Orphanage Management System is a full-featured CRUD (Create, Read, Update, Delete) application designed to manage various aspects of an orphanage. Built with SQL for the database and Bootstrap for the front-end, this system provides an efficient way to manage information related to children, staff, donors, inventory, events, and finances.

Features

• Child Management: Create, view, update, and delete records of children in the orphanage.
• Staff Management: Handle CRUD operations for staff member details and their roles.
• Donor Management: Manage donor information and their contributions with CRUD functionality.
• Inventory Management: Keep track of inventory items with complete CRUD capabilities.
• Event Management: Organize and manage events with full CRUD support.
• Financial Management: Record, view, update, and delete financial transactions.

Technologies Used

• Front-End: HTML, CSS, Bootstrap
• Back-End: SQL (Structured Query Language)
• DBMS: MySQL / PostgreSQL / SQLite (Specify the database management system you used)
• Tools: (e.g., MySQL Workbench, DBeaver, Visual Studio Code)

Installation

1. Clone the Repository

   git clone https://github.com/keyy-tech/Sunshine-Haven-Orphanage.git

2. Import the SQL File

   • Open your preferred SQL database management tool.
   • Create a new database (e.g., sunshine_haven_orphanage_db).
   • Import the How about "Sunshine Haven Orphanage".sql file into the newly created database.

3. Set Up the Application

   • Install necessary dependencies (if applicable).
   • Configure the database connection settings in your application.

4. Run the Application

   • Start the server (if applicable) and open the application in your browser.
   • The application will provide a user interface for managing orphanage data.

Usage

• Child Management: Add, view, update, or delete child records through a user-friendly interface.
• Staff Management: Manage staff member details, roles, and responsibilities.
• Donor Management: Track and manage donor information and contributions.
• Inventory Management: Add, view, update, or delete inventory items.
• Event Management: Schedule and manage events within the orphanage.
• Financial Management: Record financial transactions and manage budgets.

Database Structure

The database includes the following tables (please list the actual table names from your SQL file):

• children: Stores information about the children in the orphanage.
• staff: Contains staff member details and their roles.
• donors: Records donor information and their contributions.
• inventory: Manages orphanage inventory.
• events: Tracks events and activities.
• financial_transactions: Manages the financial records of the orphanage.

Front-End Interface

The application uses Bootstrap for a responsive and modern user interface, ensuring that the system is easy to navigate and accessible across devices.

Contributing

Contributions are welcome! Please follow these steps to contribute:

1. Fork the repository.
2. Create a new branch: git checkout -b feature-branch-name.
3. Make your changes and commit them: git commit -m 'Add some feature'.
4. Push to the branch: git push origin feature-branch-name.
5. Submit a pull request.

License

This project is licensed under the MIT License. See the LICENSE file for details.

Contact

For any inquiries, please contact:

• Name: Kotoka Emmanuel Yayra Yaw
• Email: emmanuelyayrakotoka@gmail.com
• GitHub: keyy-tech

Note

1. After forking the repository.
2. Put the file into you htdocs folder if you are using xammp or www folder if you are using wammp or ammps
3. Create a username called bday.
4. Create a password called bday.
5. Run the sql code in the workbench.

---

Thank you for using the Sunshine Haven Orphanage Management System!