Fact and Dimension table
Create the Fact and Dimension table attribute and the ER data model diagram for the attributes listed below.
TRANSACTIONPARTITIONKEY
TRANSACTIONKEY
DAYPARTKEY
TRANSACTIONDATEKEY
BUSINESSDATEKEY
PROFITCENTERKEY
STOREKEY
STORESTATUSKEY
ORGANIZATIONKEY
PERIODICORGANIZATIONKEY
REGISTERKEY
PTXGUID
CHARGES
DEBIT
DISCOUNTS
TAXES
REMITTANCE
GUESTCOUNT
DRAWERKEY
DEBITAMT
REFUNDAMT
SSSCOUNT
STORESTATUS2KEY
PROFITCENTERKEY_ORIG
CATERINGKEY
MISCCHARGES
CREATEDTIME
Create the Fact and Dimension table attribute and the ER data model diagram for the attributes listed below.
