Your fact and dimension tables
Quantity: The quantity describe the number of items to be placed by the particular member of the Gym who opt the membership in the Gym.
Membership_Name: The Membership_Name represent the name of the member who opt the membership of the Gym.
Date: The date represent the date on which day the customer or the member of the Gym purchase some item.
Event Date: The event date represent the day on which the event was organized by the CEO of the Gym for their member.
Member Fact Table
OneDayPass
| MID | MNAME | IID | OID |
|---|---|---|---|
| 111 | Joe | EQ1 | 11113 |
| 222 | Mary | AP2 | 11112 |
| 333 | Sue | AP1 | 11111 |
Dimension Table 2:
Dimension Table 3:
| MID | MNAME | IID | OID | DATE | PRICE |
|---|---|---|---|---|---|
| 111 | Joe | EQ1 | 11113 | 2004-01-03 | 12 |
| 222 | Mary | AP2 | 11112 | 2004-01-02 | 9 |
| 333 | Sue | AP1 | 11111 | 2004-01-01 | 11 |
| 444 | Sears | AB1 | 11114 | 2004-03-04 | 13 |
| 555 | John | CD2 | 11115 | 2004-02-06 | 15 |