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