Data model
Create the Data model (Create the Fact and Dimension table attributes) and possible 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 Data model (Create the Fact and Dimension table attributes) and possible data model diagram for the attributes listed below.
