Web enabled database for sailing courses
$100-300 USD
Pagado a la entrega
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
Nº del proyecto: #3602484