I need a database of every tattoo convention that is happening in the world for 2013.
The database should contain the following data for each convention:
- Tattoo Convention Name
- Official Website
- Dates that it is taking place
- City, State, Country that it is held in
- Link to Image of convention flyer / poster
- All artists that are attending the convention
For the Artist listing, this is the data we need for each artist
- Artist Name
- Name of the studio they work at
- City, State, Country their studio is in
- Artist / Studio website URL
- URL of an image of the artist (if available)
The table structure should be setup so that I can find all artists that are attending a studio, find all conventions an artist is attending, find all artists that belong to a studio, find all conventions a studio will be at, find all artists that are in a studio.
Most likely it'll be a table structure of:
[CONVENTIONS] [ARTISTS] [STUDIOS]
With a link between all three based on a Unique identifier
Once you are complete and deliver the database, I will spend 1 day to go through it to verify that all tattoo conventions are in it. If more than 5 conventions are missing, the project will be considered not complete. It's imperative that EVERY tattoo convention in the world be in here.
Any questions, please let me know!
Additional Project Description:
02/21/2013 at 23:20 AKST
*** IMPORTANT ***
If you even mention that you want to do this in Excel, your bid will be declined.
This must be in a database so that all the data is linked together
There should be linking tables so that the data isn't duplicated. There should be 1 artist linked to every convention they will be at and linked to the studio they work at.