hierarchy dimension in retail fitness centr with Sale Fact Table

Attributes: SaleID$($PK$),$ SaleDate, FranchID$($FK$),$ MmbrID$($FK$),$ MerchID$($FK$),$ ServPurchID$($FK$)$

Dimensions:

$1.$ Franchise Dimension

$$ Attributes: FranchID$($PK$),$ FranchRegion, FranchPostalCode, FranchModelType

$2.$ Member Dimension

$$ Attributes: MmbrID$($PK$),$ MmbrName, MmbrZip, MmbrEmail, MmbrDate

$3.$ Mechandise Dimension

$$ Attributes: MerchID$($PK$),$MerchName, MerchPrice, MerchType

$4.$ ServPurchase Dimension

$$ Attributes: ServPurchID$($PK$),$ ServPurchDate