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.

Acompany using the perpetual inventory system purchased inventory worth $540,000 on account with credit terms of 2/15, n/45. defective inventory of $40,000 was returned 2 days later, and the accounts were appropriately adjusted. if the company paid the invoice 20 days later, the journal entry to record the payment would be

Grey company holds an overdue note receivable of $800,000 plus recorded accrued interest of $64,000. the effective interest rate is 8%. as the result of a court-imposed settlement on december 31, year 3, grey agreed to the following restructuring arrangement: reduced the principal obligation to $600,000.forgave the $64,000 accrued interest.extended the maturity date to december 31, year 5.annual interest of $40,000 is to be paid to grey on december 31, year 4 and year 5. the present value of the interest and principal payments to be received by grey company discounted for two years at 8% is $585,734. grey does not elect the fair value option for reporting the debt modification. on december 31, year 3, grey would recognize a valuation allowance for impaired loans of

When sending a claim to an insurance company for services provided by the physician, why are both icd-10 and cpt codes required to be submitted? how are these codes dependent upon each other? what would be the result of not submitting both codes on a medical claim to an insurance company?