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
In cell D7, create a formula that calculates the tax for the invoice and use a sales tax rate of 7.5%.
Open our practice workbook. Click the Challenge worksheet tab in the bottom-left of the workbook. In cell D7, create a formula that calculates the tax for the invoice. Use a sales tax rate of 7.5%. In cell D8, create a formula that finds the total for the order. In other words, this formula should add […]