Uncategorized
Create the Data model
Learning Goal: I’m working on a engineering discussion question and need an explanation and answer to help me learn.
Create the Fact and Dimension table attributes
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