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.
5 freelancers are bidding on average $336 for this job
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.