May 27th Project's requirements

We got the email from Dr. Kanwar Vikram today about the information he wants to store in the DB.
Since another group is doing the database for the patients, the thing we need to do is to develop a DB for donors and donations.
After reading the email, we found out several characteristic the DB should have.

Data:

For donor:
personal ID(primary key), name, address (included city, state, zip-code),
contact info(email, mobile, landline),
cumulative donation

For donation:
donation ID(primary key), amount of donation,
when, to whom, from whom(donor's ID),


============
Because we generate a unique donation ID for each donation and it contains a donor's ID.
This works like the recipe.

Other functionalities:

* a user system, which can enable the donor can sign up an account and login.
It lets the donors to check their previous donations and the total amount.
Also, it has admin accounts which can check all these things happen.

* an email system, which can send out the monthly or semi-annually summary to the user.

* a payment system, enables donor can donate online.

May 22nd Intro Presentation

p1

Publish at Scribd or explore others: rcos ngodb

May 19th Welcome!

http://www.cankidsindia.org/

Welcome to NGO Database Design project!

Our goals to this project is:

1. To create a database which stores all details about 3000-4000 children to provide an extensive information base.

2. To give out clear data statistic analysis and strong data management tools.


Using Language: Ruby, Ruby on Rails

Using Database: MySQL

------------------------------------

Develop Schedule for Summer 09:

May: DB Design
- Tables relationships, update methods, arrangements, algorithm design
- Learning RoR

June: RoR & DB
- Connection between RoR and MySQL,
- Create, Read, Update, Destroy method design,
- Authentications, I\O operations

July: GUI Design
- CSS or JS Coding, enhance the display

August: Debug & Testing
- Final testing,
- Hopefully Beta version of this project will be ready.

------------------------------------


And finally, please let me say thank you to Sean O'Sullivan '85 and Professor Krishnamoorthy, who provide fully supports to RCOS and this project.


------------------------------------
More details will be posted later.