Reference no: EM133147806
Central Hospital is a fictional general hospital located in more than 50 locations. Each local central hospital has more than 70 departments (e.g. Emergency, Allergy, Cancer Care, Pediatrics, Pharmacy), hundreds of doctors, nurses, and staff.
A special service provided by Central Hospital is patients have their medical accounts. They can deposit money in advance to their accounts with extra credits. For example, by depositing $75 in advance in the medical accounts, patients will receive $100 credits and can use them for paying all the bills generated by the hospital. There's no expiration date for the credits in the accounts.
Every time a patient visited the central hospital, a bill will be generated. The majority of the bill will be paid by insurance companies. For the remaining balance of the bill, the patient can pay them using the credits from the medical account, cash, credit cards, debit cards, and so on.
Central Hospital wants to build a data warehouse and use the data warehouse to answer the following questions:
(1). Which local central hospitals, what departments and what doctors are generating most of the bills?
(2). Who are our patients, and how are they paying for their bills?
(3). What is the daily balance of credit in a medical account?
(4). What is the % used and % left of credits in the medical accounts given in a particular month?
(5). When filling claims to patients' insurance companies, what is the average duration between the claim filling date and the payment receipt date?
To answer the above questions, please design a dimensional model (star schema) to include all the necessary dimensions and facts by following the steps: (1). Identify the business process; (2). Determine the dimensions; (3). Identify the facts; (4). Draw the star schema by connecting the tables. If you need more than one fact table in your model.
For the definitions of dimension and fact tables, please use the metadata tables with the following columns:
Column Name Nullable Description
Use ERDPlus (https://erdplus.com ) to create the star schema
|
Process of entering and contracting
: 2. Empathy is one of the key issues that could face an OD practitioner in the process of entering and contracting. Discuss the issue of 'empathy' in the context
|
|
How much is the gain or loss on retirement of bonds
: On May 1, 2022, the company retired P 1,000,000 face value bonds at 101. How much is the gain or loss on retirement of bonds taken to profit or loss
|
|
Could 3m survive without intrapreneuring
: 3. Is it healthy for a corporation to be involved in widely diverse industries such as Scotch tape and bioelectronic ears? Doesn't that prevent the corporation
|
|
Exploring complex data visualization
: Exercise - Exploring complex data visualization - Create a filled map to display population density and create a slopegraph and to allow you to be familiar
|
|
Build a data warehouse
: Central Hospital is a fictional general hospital located in more than 50 locations. Each local central hospital has more than 70 departments (e.g. Emergency, Al
|
|
What amount should be reported as accrued liability
: The attorney advised that it is probable that Grapes will be awarded P3,000,000. What amount should be reported as accrued liability
|
|
Example of something that should follow normal distribution
: Offer an example of something that should follow a normal distribution. Don't use examples discussed in the notes.
|
|
Characteristics of a binomial experiment
: Many business activities generate data that can be thought of as random. An example described in the textbook is the servicing of cars at an oil change shop. Ea
|
|
Memo-create economic-social and environmental value
: Write a memo to the CEO of the company you've been assessing throughout the course, outlining your plan to create economic, social, and environmental value.
|