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