I have data about monitoring stations. For now it is stored in Excel tabs. I have decided to try to make a database. It will be my first contact with databases. Here is an example how it looks now in Excel
Typ Station name Typ of area Location long lat Time/date/concent pm Kittsee suburban background SO2 Oberschützen rural traffic SO2 Kittsee suburban background .... ....
As you can see some stations occur two or more times. So I have decided to put them in another tab as
typ_id typ 1 pm 2 SO2
then put station_id and typ_id together in the next tab
typ_id station_id 1 1 2 1 2 2
So my question is can I use this approach for location and area? So columns in my main table will look like this:
station_id typ_id station_name area_id location_id long lat time_date_conc