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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment