PLEASE I NEED A DATABASE ADMINISTRATOR WHO CAN HELP ME DEFINE A LIST OF FIELDS I CAN USE FOR A MOSQUE DATABASE ?

WHAT KING OF INFORMATION SHOULD I INCLUDE AND ON WHAT PLATFORM CAN I GET A BEST RESULT?

IT SHOULD INCLUDE FIELDS LIKE DONATORS, AMOUNT, SEX, ETC.

REGARDS.

saddik,

no offense but seeing you have started the show with 3 fields, I say you are on the right track. Why not list the fields you have in mind and then on our end, we tell you whether or not they make sense?

i have developed one dat works for church, hmmm mosques? it will definately. since its humans that attend there one can easily modify for mosque. is it gonna be web based or desktop application? dats no big deal though

Thanks for the input from u all.

Skima i would like it to be a desktop application which will be web based at a much later time.

Pls can u shed more light on the one u did for the church? i.e what fields did u gather? what softwares used, etc.

regards.

Men u are a gud programmer,since u are about 2 write a program 4 the mosque/church.but y not u have some tin gud for the society at whole.

i used basically PHP/MYSQL .

it collects personal data of a member, their children info, marital detail and all info. so its relate them with all their relative in the church. so as an overseer of the church you can make various queries. you can search for all married people in the church, you can search for all the singles, you can search for all the unemployed, imminent! am not running on my system now i would have listed all the whole features. more so, the application was built with the web in mind. so it can run locally and on line. it can merge data. do backup etc.


my phone number: 08027924441 email: possicon at yahoo dot com

Do you said, you need what you can use to collects personal data of a member, their children info, marital detail and it should be desktop application?


I can developed the application for you,  it will be inform of software which you can install on any system or computer  you want.

for more informatin contact email:delongpet23@yahoo.com

saddik:

PLEASE I NEED A DATABASE ADMINISTRATOR WHO CAN HELP ME DEFINE A LIST OF FIELDS I CAN USE FOR A MOSQUE DATABASE ?

WHAT KING OF INFORMATION SHOULD I INCLUDE AND ON WHAT PLATFORM CAN I GET A BEST RESULT?

IT SHOULD INCLUDE FIELDS LIKE DONATORS, AMOUNT, SEX, ETC.

REGARDS.

I don't know what you want to track/store but basically the following are ideal fields for table "Mosque Members":
FirstName
SurName
DOB(Day,Month,Year)
Sex
Email
Home Address
City
State
Pry PhoneNumber
Secondary PhoneNumber
MosqueID (primary key - unique).

You can add another table "Contributions".Add fields showing donation for month e.g Jan and link the MosqueID of the donator with that of MosqueID in the Meber table.That way you can query donations based matching mosqueID.

If you want to make it a web application, you can use WAMP(Windows Apache MySQL Php).

You can down a free one at http://www.wampserver.com/en/.I have an ebook that I can share with you, but the file is about 14MB.I can email it to you if you contact me.

Feel free to let me know if I can be of further assistance.

I agree with Panche but I think the OP is going about the solution the wrong way. The first thing that you need to know is what your requirements are. Is the database required to keep track of contributions or keep track of mosque members or do you just want a generic database that stores everything pertaining to the mosque?

Depending on what your needs/requirements are that will inform what fields you need to add to your database.

Inline with what Wallie said,it will be ideal if you can post your requirements.It will also help you to measure the effectiveness of your app.

I appreciate all ur contributions,

Panuche and wallie in specific, i would like to respond that it will contain both contributors as well as members.

So i must say it should be generic, and finally panuche i would appreciate the e-book.

Regards.