Sedang Disiapkan

Member database

Membership tatabase for non profit organisation.

Key elements:

1. All person database

2. Relation between persons (family)

3. Person can joined to groups or acivitys

4. Log of payment for activity

Aditional detaisl

Table with person database including:
• Name
• Date of birth
• Address (selectable area/town/county in Ireland)
• Phone (with international prefix)
• Email
• Mowed to Ireland in (year)
• Occupation (selectable from list or to be added to list on the go)
• Interests / hobbies
• Data updated (has to be added automatically when information changed / updated)
• Do not contact (y/n)
• Comments (unlimited amount – logged by date entered an person who did coment)
Table joining members in families (e.g. person 1 & 45 is parents to person 30)
Member database
• Any person of the person table can subscribe as member
• To be member person has to do membership payment
• Payment will grant membership for 1 year
• Payment can be changed from year to year (additional tick box to show only active payments on payment form)
• Additional field for donation that can be made @ time when membership fee is paid or separately
• Membership payment is only process to become member (there may be 0 EUR payment for special situations)
• Report of members and upcoming expiry of membership has to be made.
Activity database
• Any person in person database (members or non members) can join to different activity clubs
• Extra fee may haw to be paid to enter club
• The process of applying for club and payment is separated, unlike membership scenario.
• There may be different payment types for the club (member / non member), but every payment has starting and expiry date. Like 20 EUR from September to December & 10 EUR for September only. Some y/n tick box has to be used to filter unused payment types on form.
• When adding new club member start date of payment has to be selectable an can be different from joining date. (person is joining to club in middle of august, but fist payment has to be made from September)
• Any club may haw a sub grouping (like tradition dance class: group 1 > teacher MS X; Group 2 > teacher MR Y .... ).
• Report of persons in each club / subgroup and payments has to be made
Forms:
• New member form
• New club participant form (with option to add new entry to database if new participant does not exist in database)
• In participant or member form additional data with names of family members has to be displayed
• Payment form where member can be searched and all paid / unpaid fees displayed
• Main database with selectable filters for members and participants of the group and custom filters
Additional features
• User level switchboard with user groups and permissions any change that users make has to be recorded with time and name
o Read only (access to specific groups only)
o Read / write (access to specific groups only)
o Master user
o Admin (can change data and log changes under different name)
• As unique identification for persons Name + Second name + DOB has to be used to avoid duplicate records.
• Any new entry after updating Name + Second name + DOB has to be compared to existing db and if this person exists – message box has to be displayed
• All database has to be ready to be exported to mysql

Kemahiran: Pentadbiran Pangkalan Data, Microsoft Access, PHP, SQL

Lihat lebih lanjut: membership family, member database, non profit organisation, log log database, http activity url log mac os, database member login photo sharing website template, database log log, log database php, non member, membership php database, php database log, wordpress plugin database member edit profile address, php membership database, php sql membership, php membership sql, abledating member database, find member database php, membership database, boonex dolphin 1000 member database, database design family, mail non member groups yahoo, joomla member groups

Tentang Majikan:
( 0 ulasan ) Dublin, Ireland

ID Projek: #1598339

9 freelancers are bidding on average €148 for this job

Dunkoh

Ready to start immediately. See PMB.

€200 EUR dalam 3 hari
(108 Ulasan)
6.8
kulhanekd

I have 15 years exp in access design. I can build the database you want. Thanks Donna

€50 EUR dalam sehari
(36 Ulasan)
5.9
PerfectSquare

Hi I am professional in creating the databases. I have experience in creating and managing the large and small databases. I will provide the complete solutions. Thans

€150 EUR dalam 5 hari
(29 Ulasan)
4.2
nobelsolution

Hi, I am ready to start. Please check pmb for more details.

€210 EUR dalam 10 hari
(12 Ulasan)
4.2
kumar241915

Hi, I have worked on similar kind of projects. Please let me know if you are interested to work with me. Thanks & Regards, Kumar [url removed, login to view]

€30 EUR dalam 4 hari
(1 Ulasan)
0.5
Juaninfotech111

PLEASE CHECK PMB

€220 EUR dalam 5 hari
(0 Ulasan)
0.0
nish20in

Hi, I am an Database technical architect having experience of over 6 years in designing the database structured. Please check the Private message for more details Regards Nish

€70 EUR dalam 2 hari
(0 Ulasan)
0.0
alvicreatives

Hi, Alvicreatives has been long into web application development & designing and development business. The last 5 years, we are working on web based ASP.net / C#, Sqlserver 2005/2008, Ajax, CSS, Flash,PHP,MySql,Wor Lagi

€200 EUR dalam 5 hari
(1 Ulasan)
2.8
MohanParamane

Hi, We are Pune (India) based company working since 1996. We will complete your work in time. We provide online support for software and customer satisfaction is our goal. Please see the private message box. Regards

€200 EUR dalam 3 hari
(1 Ulasan)
0.0