An ecological database tracks marine research at various reef locations. There is a one-to-many relationship between these tables:
| tbl_ReefSites |
|---|
| ReefID |
| ReefName |
| Latitude |
| Longitude |
| tbl_SpeciesSightings |
|---|
| SightingID |
| SpeciesName |
| Count |
| ReefID |
| SightingTimestamp |
To establish this relationship:
Identify the common field name that must be used to link these two tables.
State which of the two tables represents the 'many' side of this relationship.
