Page History
...
The main tables used in Ski Team examples are:
Athlete Fact | This contains information about each athlete and their participation on a camp. In this database the person fact will generally have one record for each camp and each person for every year. The fact record is concerned about the individual trips for each program. |
|---|---|
Camp | This is a dimensional table which contains information about each camp. For example the name and location of the camp. Camp ID is the Key to this table. |
Person | The person table contains information about the athlete such as name and address details. Person ID is the Key to this table. |
...