Please design a data warehouse using star schema or snowflake schema that solves a specific business intelligence task that you come up with. Only one fact table is needed. You will need to include 1) a problem statement (i. e. what is the purpose this warehouse is serving) 2) an ER diagram describing the designed schema 3) justification for your fact table and dimensions. You can include all components in a word document. Some tasks you can consider: analyzing sales, analyzing hospitalized patients, analyzing student performances, etc.

Exercise 7-7 martinez company reports the following financial information before adjustments. dr. cr. accounts receivable $168,900 allowance for doubtful accounts $3,200 sales revenue (all on credit) 849,300 sales returns and allowances 50,440 prepare the journal entry to record bad debt expense assuming martinez company estimates bad debts at (a) 4% of accounts receivable and (b) 4% of accounts receivable but allowance for doubtful accounts had a $1,550 debit balance. (if no entry is required, select "no entry" for the account titles and enter 0 for the amounts. credit account titles are automatically indented when the amount is entered. do not indent manually.)