All data were taken from Kaggle - Metallica Tour History.
I split the data into seven main parts:
- Tour
- City - State - Country
- Album
- Song
- Acts
- Instrument
- Event URL
and created this ER diagram.
There are three pages on this website. The first page contains 11 questions about the data, sql statements of this questions and answers. The second page contains the first 30 lines of the Tour table. The third contains 30 lines of the table, which contains the states and countries of the cities.