I'm dusting of my SQL, and would love to know if I've got my mental ER-diagram right.
Basically, I've got 10-15 different datasets (actividades) from several locations (islas) over the span of a few months. My first instinct is to separate the many-to-many relationship between Islas and Actividades into an intermediary table, then reference(/index?) each dataset by location.
If this is the correct approach, I'm then wondering whether there is any benefit to have a separate date table (I guess this would be kind of like a calender). ie: the join between location, date and dataset would give one result, querying a date and location would give a list of all the activities that day and querying a single date would give all datasets from all locations.
Or should I just datestamp each datapoint (of each dataset) and deal with this in my queries.
I hope that was legible, thanks for your help!