Find Jobs
Hire Freelancers

Create membership database

$30-50 USD

Completed
Posted over 13 years ago

$30-50 USD

Paid on delivery
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
Project ID: 3686840

About the project

17 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (34 reviews)
5.4
5.4
17 freelancers are bidding on average $36 USD for this job
User Avatar
See private message.
$42.50 USD in 7 days
4.9 (190 reviews)
6.1
6.1
User Avatar
See private message.
$34 USD in 7 days
4.9 (17 reviews)
3.7
3.7
User Avatar
See private message.
$25.50 USD in 7 days
5.0 (9 reviews)
3.6
3.6
User Avatar
See private message.
$34 USD in 7 days
4.9 (14 reviews)
3.4
3.4
User Avatar
See private message.
$29.75 USD in 7 days
4.9 (17 reviews)
3.3
3.3
User Avatar
See private message.
$42.50 USD in 7 days
2.6 (8 reviews)
3.6
3.6
User Avatar
See private message.
$21.25 USD in 7 days
4.2 (3 reviews)
1.3
1.3
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (1 review)
0.1
0.1
User Avatar
See private message.
$38.25 USD in 7 days
5.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$25.50 USD in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$34 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$33.15 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 7 days
0.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$39.10 USD in 7 days
0.0 (1 review)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
4.4
2
Member since Aug 25, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.