1st Attempt

[Grant Dawson]

I'm attempting to build my first database and have decided to use MYSQL to do it, I've downloaded MYSQL and Workbench and got both up and running.

What I am trying to do is create a database of "Year End Chart Hits" from both the UK and US, I have lists of the 100 songs that made the YEC's since 1960 until present.

How should I create Table(s) that will allow me to create a list that not only tells me which songs were hits in the UK and US in the same year but also if it was a hit previously? Any help would be greatly appreciated.

As an example:

"Bad Habits" by "Ed Sheeran"

2021 #10 in the UK and #15 in the US
2022 #7 in the UK and #1 in the US
2023 #62 in the UK

I want to be able to create lists that give me both UK and US positions in 2021, both positions in 2022 but something(coloured, highlighted, not sure) to signify that it was a hit in a previous year and the same for 2023.

Again any help suggestion greatly appreciated

Grant

Grant Dawson