Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 5
Words: 440

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
Copyright © 2009-2023 UrgentHomework.com, All right reserved.