Web enabled database for sailing courses

Cancelled Posted Jun 26, 2006 Paid on delivery
Cancelled Paid on delivery

We run an e-commerce site selling sailing and watersports equipment. We want to set up a database to enable outdoor centres and sailing clubs to advertise sailing courses that they are running. This would attract people who are interested in sailing to our site and hopefully enable us to sell more from our site. We may also be able to charge sailing clubs to advertise on the site.

The database must have the following features.

A registration page to enable outdoor centres and sailing clubs to obtain a username and password.

Once they have obtained a username and password the outdoor centres and sailing clubs can register their details (brief overview, location map, photographs of facilities, contact details, web site etc)

A database of sailing courses (type of course, location, date, course provider, cost etc). Each sailing centre must be able to access this database via a user friendly form to add, edit or delete sailing courses that they offer.

A search facility to enable visitors to the site to search for sailing courses by type of course, location, date, course provider etc etc

This is a very simple overview. Depending on the success of the initial database we may expand it to cover sailing holidays.

I am interested in receiving initial ball park estimates before going into detail.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Thursday Jun 29, 2006 8:53:09 AM:

I have written a more detailed spec for this project. If you e-mail me it is available as a word document.

Specification for Outdoor Courses Database

1 Background

[url removed, login to view] is a UK based e-commerce site selling sailing equipment.

[url removed, login to view] is a UK based e-commerce site selling canoeing equipment

We would like to increase the number of visitors to these sites. We also believe there is a gap in the market for an online database of outdoor courses. By providing such a database we believe we can:

1. Direct people who are interested in sailing and canoeing to the above sites so they can purchase equipment.

2. Direct outdoor centres who provide sailing and canoeing courses to the above sites so they can purchase equipment.

3. Increase the number of inbound links to the above sites, thus improving the organic search engine rankings.

4. Earn i ncome from banner advertising through affiliate schemes with other online stores selling outdoor equipment.

5. In the future, depending on the success of the initial site, charge outdoor centres to register their courses on the site.

2 Courses Database ??" Key Requirements

2.1 User Levels

The database will have three user levels:

1) Administrator

2) Course provider

3) User

2.2 Access Restrictions

Administrator access is controlled by username and password. The administrator must be able to access all the data within the database. Administrator access will be via a web page.

Course providers must initially create an account by providing contact details and a username and password. Once they have created an account they can add, edit, view and delete the details of the courses they have on offer. Course provider access will be via a web page.

Users can search the database and view courses. No username or password is required. User access will be via a web page.

2.3 Tables

This is an initial outline of the tables required within the database. This may be modified or altered as the development progresses.

2.3.1 Course Provider Contact Details

Username

Password

Organisation Type Linked to Organisation Type table (2.3.5

Name of Company Linked to Course Details table (2.3.9)

Name of Contact

Address 1

Address 2

Address 3

Address 5

Address 6

Post Code

Region Linked to Region table (2.3.6)

Country

Email address 1

Email address 2

Phone number 1

Phone Number 2

Fax Number

Web Page 1

Web Page 2

Banner image of course provider

Administrator can add additional fields if required

2.3.2 Sport Category

Sailing

Kayaking

Hillwalking

Mountaineering

Rockclimbing

Potholing

Scuba Diving

Administrator can add additional sports if required

2.3.3 Sub Sport Category

Eg for the sport of Sailing the following sub-sport categories would apply

Sail Cruising

Motor Cruising

Powe rboating

Specialist Sailing

Sailing Navigation

Dinghy Sailing

Multi-Hull Sailing

Windsurfing

Personal Watercraft

Inland Waterways

Administrator can add sub-sport categories to each sport if required

2.3.4 Course Title

Eg for the sub-sport of Sail Cruising, the following Course Titles would apply

RYA Start Yachting

RYA Competent Crew

RYA Day Skipper (tidal)

RYA Day Skipper (non-tidal)

RYA Coastal Skipper (tidal)

RYA Coastal Skipper (non-tidal)

Administrator can add Course Titles to each sub-sport category.

2.3.5 Organisation Type

Sailing Club

Marina

Outdoor Centre

Freelance Instructor

Administrator can add organisation types.

2.3.6 Regions Table

Scotland

North West

North East

Wales

Yorkshire & Humberside

East Midlands

West Midlands

South West

South East

Thames Valley

Southern

Northern Ireland

Ireland

Administrator can add to regions table if required

2.3.7 Date table

When entering a course the course provider must enter the dates that the course begins and ends on. The facility must exist for courses to be added in the future (e.g for the next 10 years).

The date format used must enable users to search by exact dates (eg for sailing courses on the weekend of 15/16 July) or by month (eg for sailing courses in July) or by year (eg for sailing courses in 2007).

2.3.8 Cost table

When entering a course the course provider must be able to enter the cost of the course (to the nearest pound)

2.3.9 Course Details

Course Provider Linked to Table 2.3.1

Sport Category Linked to Table 2.3.2

Sub Sport Category Linked to Table 2.3.3

Course Title Linked to Table 2.3.4

Course Dates Linked to Table 2.4.5

Course Location This is either at the course providers location (Table 3.3.1) or at a separate location described by 2 or 3 words e.g (River Tryweryn)

Course Cost

[url removed, login to view] Banner Advert Table

We wish to place banner adverts on the site (with embedded affiliate links). Ideally dif ferent banner adverts would be displayed depending upon the type of course people were searching for. So for example, if people were searching for canoeing courses we would display a banner advert for www.canoesforsale.co.uk. If people were searching for sailing courses we would display a banner advert for www.getoutsailing.co.uk. There are numerous affiliate schemes that we can link up with depending on the sport.

2.4 Data Entry Forms

2.4.1 Course Provider ??" Registration Form

This form enables course providers to register their details (see table 2.3.1). Once they have set up a username and password and entered their details an e-mail is sent to the course provider address and to the administrators address confirming the registration process is complete.

2.4.2 Course Provider ??" Change Details Form

This form enables course providers to modify their contact details. Course providers must be logged in to update their contact details.

2.4.3 Course Provider ??" Add New Course Form

This form enables course providers to add a new course. Course providers must be logged in to add a new course.

It includes the following fields.

Choose Sport Category (from drop down list linked to table 2.3.2).

Choose Sub Sport Category (from drop down list linked to table 2.3.3)

Choose Course Title

Choose Date (ideally from an interactive calendar)

Choose Location

2.4.4 Course Provider ??" Change Course Form

This form enables course providers to change the details of the courses they offer (if the location or date has changed) or if it has been cancelled. It would be desirable if course providers could indicate if a course was full. Course providers must be logged in to change a new course.

2.4.5 User ??" Search Course Form

This form enables users to search for a course. The user must be able to search by:

· Sport

· Sport Sub Category

· Course Title

· Date (by month)

· Location (by regi on)

· Course Provider

2.4.6 Administrator ??" Add Sport Form

This form enables the administrator to add a sport to the Sport Category Table. The administrator must be logged in to access this form.

2.4.7 Administrator ??" Add Sport Sub Category Form

This form enables the administrator to add a Sport Sub Category to the Sport Sub Category Table. The administrator must be logged in to access this form.

2.4.8 Administrator ??" Add Course Title Form

This form enables the administrator to add a Course Title to the Course Title Table. The administrator must be logged in to access this form.

It may be easier/more user friendly to combine forms 2.4.7 to 2.4.8 into a single form.

2.4.9 Administrator ??" Banner Advert Management Form

This form enables the administrator to upload banner adverts and affiliate links to the site. It must be possible to link banner adverts with the appropriate sport as detailed in section [url removed, login to view]

[url removed, login to view] Administrator ??" G eneral Administration Form

The administrator must have access to all areas of the database. They must be able to delete courses, course providers etc etc. Not sure what the best way of doing this is. The administrator must be logged in to access this form.

[url removed, login to view] Administrator ??" E Mail issues

It must be possible to export the email addresses of all course providers into an appropriate file for use with standard e-mail software (Microsoft Outlook and similar).

2.5 Web Interface

The web interface must be simple and clear. Something along the lines of:

The web pages must be designed with search engine optimisation in mind.

3 Hosting

The existing e-commerce stores have been developed using Cybertill, an e-commerce package with additional stock control and EPOS features. The domains [url removed, login to view] and [url removed, login to view] are hosted by fasthosts ([url removed, login to view]) via their free hosting service. Fasthosts re-direct traffic from these domains to a Cybertill server.

It is envisaged that the database and web pages will be hosted on the FastHosts server. It is the coders responsibility to check that the FastHosts is capable of supporting the database.

4 Technology

I am open to advice on this issue. I have little experience of web enabled databases. My initial thoughts were for a mySQL database and PHP scripting.

I would consider an Access database as I understand this better but am a bit concerned it is old technology and would not be suitable for potential expansion.

The chosen software must be supported by FastHosts.

The chosen software must include the possibility for potential expansion (see below).

5 Expansion

Depending on the success of the initial, free to use database I have considered the following expansion options.

1. Charging course providers to register course details on the site. Probably via a PayPal acco unt or similar. There are numerous charging options (a flat fee to register, per course, by number of impressions).

2. Including an online booking form and earning commission from the course provider for each course booking.

3. Expanding into different countries.

4. Expanding into more general recreational courses (painting, music, dancing etc…)

5. Expanding the site to cover specialist holidays (eg sailing holidays, canoeing holidays).

6 Coder Requirements

The chosen coder must:

· Have good written and spoken English

· Be available online (e-mail and Messenger)

· Be able offer advice on site structure, operating issues

· Have a track record of delivering similar sites

· Be available in the future to assist with site expansion

· Be honest and reliable

## Platform

webserver is currently provided by [url removed, login to view]

we use the windows server package but could also be done on a linux server

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3602484

About the project

13 proposals Remote project Active Jul 31, 2006

13 freelancers are bidding on average $219 for this job

phinest

See private message.

$191.25 USD in 30 days
(93 Reviews)
6.9
zubairuddin

See private message.

$255 USD in 30 days
(63 Reviews)
6.3
briandesousavw

See private message.

$238 USD in 30 days
(71 Reviews)
5.8
anujpant

See private message.

$255 USD in 30 days
(67 Reviews)
5.5
vbdevvw

See private message.

$255 USD in 30 days
(15 Reviews)
4.2
naveedahmedsl

See private message.

$212.5 USD in 30 days
(4 Reviews)
3.0
tobyebel

See private message.

$212.5 USD in 30 days
(5 Reviews)
2.8
thecloudkernel

See private message.

$255 USD in 30 days
(2 Reviews)
0.9
rashi

See private message.

$255 USD in 30 days
(1 Review)
0.0
starkillervw

See private message.

$255 USD in 30 days
(0 Reviews)
0.0
s2flex

See private message.

$229.5 USD in 30 days
(0 Reviews)
0.0
ionuthrinca

See private message.

$102 USD in 30 days
(0 Reviews)
0.0
laiqbutt

See private message.

$127.5 USD in 30 days
(0 Reviews)
0.0