In Progress

Create membership database

I have created the tables in an access database for a four wheel drive club.?

I would like to have the system converted to MySQL with a web based front end. I think php would be suitable. it is to be hosted on a standard Linux server with a cpanel hosting account.

## Deliverables

please see attached drawing, I'm not much good at drawing :-) and some more comments to further explain the SB the MEMBERSHIPS table holds the information for each membership, this could be a family or single membership. the MEMBERS table has the data for each member. e.g. a family membership could have 4 people. it was really normalisation of the structure that created the 2 tables. each of the 4 members lives at the same address, has the same home phone number etc. there is a field MEM_TYPE in MEMBERSHIPS to indicate if it is a family or single membership. So, each MEMBERSHIP may have one or more MEMBERS. (if it's a single then there will only be one member) Each MEMBERSHIP will have one or more VEHICLES. Each MEMBERSHIP will have a MEM_CARD associated with it and over time there will be multiple MEM_CARDS for each membership as they expire. Each MEMBERSHIP will have multiple payments as each year they renew their membership and make a payment. the database is for internal use not for the general members. it is for the membership officer to use to keep track of things. I was imagining that there would be a screen and on the top half would be the MEMBERSHIP information and then the bottom half would be tabbed sections for MEMBERS, MEM_CARDS, PAYMENTS and VEHICLES. Each of the tabbed sections would then display the information associated with the MEMBERSHIP. the data for MEM_CARDS and PAYMENTS could be a simple grid view so all the records can be seen at once. MEMBERS and VEHICLES would probably be fields laid out neatly with arrows to scroll through them. the search box at the top of the screen would search on first names and surnames as a quick way to pull up someone's details. This would have to search through the MEMBERS table, so not sure if that is easy to do or not? maybe just search on the primary member for the MEMBERSHIP? Previously I have wanted this to be done in MS Access but I would like to have it created as a web based system as other people without MS Access will have to be using it. thanks Nathan

* * *This broadcast message was sent to all bidders on Monday Aug 30, 2010 2:38:50 AM:

Please note that the purpose of this system is for the membership officer at the club to maintain the data. this will include adding/deleting/updating records. If you have any further questions please ask as I would like to select a bidder soon.

## Platform

MySQL php

Skills: Microsoft Access, MySQL

See more: tables in data structure, questions of data structure, microsoft phone number, grid data structure, explain data structure, create mysql database using php, cpanel mysql database, ms access 2010, structure drawing, nathan, nathan s, grid view, deleting account, create membership, create cpanel, web grid mysql, club membership, create member, cpanel multiple account, database scroll, hosted account general account, linux mysql create, create simple access database, create database members, mysql select platform

About the Employer:
( 2 reviews ) Australia

Project ID: #3686840

Awarded to:

tgalal

See private message.

$42.5 USD in 7 days
(34 Reviews)
5.4

17 freelancers are bidding on average $36 for this job

shihan033010

See private message.

$42.5 USD in 7 days
(190 Reviews)
6.1
sytneivw

See private message.

$34 USD in 7 days
(17 Reviews)
3.7
trdesignvw

See private message.

$25.5 USD in 7 days
(9 Reviews)
3.6
johnny382

See private message.

$34 USD in 7 days
(14 Reviews)
3.4
dailyhungama

See private message.

$29.75 USD in 7 days
(17 Reviews)
3.3
aqif1hamid

See private message.

$42.5 USD in 7 days
(8 Reviews)
3.6
goluhaquevw

See private message.

$21.25 USD in 7 days
(3 Reviews)
1.3
krashmi

See private message.

$42.5 USD in 7 days
(1 Review)
0.1
giakcamp

See private message.

$38.25 USD in 7 days
(2 Reviews)
0.0
Awerker

See private message.

$25.5 USD in 7 days
(1 Review)
0.0
wabztech2

See private message.

$42.5 USD in 7 days
(0 Reviews)
0.0
yoginp

See private message.

$34 USD in 7 days
(0 Reviews)
0.0
rajivkumar2007

See private message.

$33.15 USD in 7 days
(0 Reviews)
0.0
aimindiavw

See private message.

$42.5 USD in 7 days
(2 Reviews)
0.0
closca

See private message.

$42.5 USD in 7 days
(0 Reviews)
0.0
tsoftlink

See private message.

$39.1 USD in 7 days
(1 Review)
0.0