1. Table of Contents (ToC)
  2. Introduction
  3. Front end
  4. Database design
  5. Conclusion


In September 2011 during AIT's 51st anniversary, all present witnessed the soft launch of the AIT Fundraising Campaign, graciously presided over by Her Royal Highness Princess Maha Chakri Sirindhorn, an AIT Alumna and also honorary faculty member. The total campaign period is 7 years (2010 - 2016) with the initial / silent phase focusing on internal members, while the public phase focusing on the philanthropists, corporate, foundations, etc. will run over the later part of the campaign.

As Royal patron of the AIT Fundraising Campaign, HRH Princess Sirindhorn also witnessed the soft launch of the Friends of AIT (FoAIT) Foundation which was established with HRH Princess Sirindhorn's own private donation of 1 million Baht in 2007. In collaboration with senior and prominent AIT Alumni, work is also undertaken to register the Friends of AIT (FoAIT) Foundation as a non-profit organization. The foundation will be the intermediary between donors and AIT.

In order to maintain as much as details possible of the constituents, it is necessary to maintain a proper database. In this regard, to serve our requirements, we initiated to develop a web based system known as FoAIT Foundation - Fund Raising Management System (FoAIT-FRMS).

Information flow

No image

Friends of AIT (FoAIT) Foundation - Fundraising Management System (FRMS)

The proposed system has the following functionalities incorporated into the system:
- Platform: The said system is a web based system.
- Front end: The user can interact with the system through any browser.
- Database: The backend is created using MySQL open source relational database management system (RDMS).
- Data connectivity: PHP is used to connect the frontend and backend.
- Users: The staff of the fundraising office will be the users of the system through a simple and secure login system.
- Stored information: Initially the system stores information of donors, volunteers, former faculty, foundations, philanthropists, contacts and prospects. In addition the system also displays details of the individual donors. Since we already have an alumni database, we plan to display the information only from the database through our interface.
- Processes: The system is able to create, edit and delete data on the above mentioned entities depending on the different user levels.
- Reports: The system generate a summary of reports (including graphs) on the campaign and individual reports especially for donors and all other constituents, such as amount pledged, amount received at present, donor request for use of funds, where the amount is at present, interest received, etc.


Benefits of using the system

Following are the benefits of using the software:
- Store all detailed information systematically.
- Update information by simply login to the system.
- Generate reports at any given time.
- Easy drill down search mechanism.
- Generate customized reports as well.