In Progress

Music Festival MySQL database creation and implementation

The Goal: To have designed and implemented a mySQL database in which contains information about upcoming festivals and the associated bands. The aim is to keep everything as simple as possible with only the essential information stored. This is to reduce the time it takes to collate the information. While the database will start simple, the goal is to continue expanding as time goes on.

Tables & Fields:

I have created a fairly specific list of tables and fields, their descriptions along with some calculations and examples are included. Although they are specific, I am not a database designer so they are only intended as a guideline. You're welcome to be as creative as needed to come up with a functional design.

The main tables of this database are 'Festivals' and 'Bands'. The input of the records is intended to be done via *.csv for 'Festivals'. The records in 'Bands' are to be created automatically whenever a band not previously in the database is imported as part of the festival line-up. Each record in 'Bands' is to be populated with information using [url removed, login to view]'s API.

The data presented on the website needs to be displayed in the following ways:

->Any combination of the following for Festivals:

==Sorted by Date

==Divided into countries

==Filtered to a continent/country/state/city

==Filtered to a festival type (eg. Outdoor, Multi-venue)

==Filtered by a selected band playing

==Filtered by a selected date range

We have hosting that supports mySQL databases, we will supply the details for this host upon agreement. Once the database has been created and is live, we would like for the coding be written in order to display the results of queries so that we can implement it into our html. We will work with you to create the design for this when the time comes.

Other tables to be included in the design include Genres, Sub-Genres, Countries, Provinces and Cities

Every time a new festival or band is imported into the database, a new html page for that festival/band will need to be automatically created and populated with data from the database. We have already created the website and have it running manually, so no website design is required, just integration.

You must be able to supply with a portfolio of similar work.

Skills: HTML, MySQL, XML

See more: mysql festival database, festival mysql, music festival database, website creation order, re creation design, portfolio descriptions, part time designer needed, mysql city state database, music by design, it database website designer, html display designer, html coding for website creation, examples databases, everything sorted, designer needed on line, databases examples, country state and city database mysql, coding for website creation, band portfolio, creative display, website creation using html, new venue, mysql database , mysql database design, music record

About the Employer:
( 9 reviews ) Ft Lauderdale, United States

Project ID: #1497595

Awarded to:

chandlerbing

Hi, Check pm, plz.

$400 USD in 20 days
(53 Reviews)
5.7

5 freelancers are bidding on average $336 for this job

zeke

Expert PHP/SQL developer with over 6 years of experience. Available to start immediately and finish within 2 days. Best Regards, Zeke

$300 USD in 2 days
(21 Reviews)
5.4
rfuentescruz

Hi. Bid details to be sent in your PMB

$250 USD in 5 days
(4 Reviews)
3.2
CoRfr

Hi, I can deliver such project quickly, with a simple architecture as requested. I lately designed a database to gather test results from various environments, system is now in production and running smoothly.

$400 USD in 4 days
(0 Reviews)
0.0
djloopool

Very experienced database designer, and besides that an active musician, so the field is fairly familiar. I will post references if needed...

$330 USD in 2 days
(0 Reviews)
0.0