Closed

Music Festival MySQL database creation and implementation

This project was awarded to chandlerbing for $400 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$250 - $750 USD
Total Bids
5
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online