Develop a star schema for a data warehouse

Reference no: EM133635286

Case: For this assignment, you will design a star schema to transform data from transactional to analytical for one topic. Read the following case and the instructions for completing this assignment.

Case: Equipment Usage Statistics

The hospital's radiology department database tracks the equipment usage, measured by the number of patients who are being imaged. This database records the date and time the equipment is being used and the type of equipment being used. This tracking allows the department to prepare its budget.

Instructions

Your assignment is to develop a star schema for a data warehouse that will keep track of the imaging equipment usage statistics. You will need to design this so the warehouse can do the following:

Show the total number of equipment uses by different time periods
Show usage numbers by time period (daily, weekly, monthly, quarterly, annually) and by equipment (x-ray, MRI)
Hint: To do this, you may need to perform three steps:

Define the main facts to be analyzed-these would be found in the table that would become the source of information.

Identify the dimensions-these would be the tables that can be used to slice and dice the main facts.

Draw the star schema using information from steps 1 and 2.

Reference no: EM133635286

Questions Cloud

What are alternative courses of action that could be taken : This Gen Xer technician defends herself to her coworkers by explaining she is not using patient names. How should management handle this situation?

Concept of self-actualization : Humanistic personality theorists placed much emphasis on the concept of self-actualization. Review the theories of Abraham Maslow and Carl Rogers.

Discuss immigration : How can multi-cultural psychology positively influence policies and practices regarding immigration?

Application of a short arm, non-mobile splint : Application of a short arm, non-mobile splint was applied until the patient can be seen by an orthopedic provider

Develop a star schema for a data warehouse : Define the main facts to be analyzed-these would be found in the table that would become the source of information. Identify the dimensions-these would be

What classes of drugs are used in the management : What classes of drugs are used in the management of depression? . What would be the initial pharmacotherapy management plan for the patient's depression

What do you believe are the most important principles : What do you believe are the most important principles for the health educator to follow? For each principle you list, discuss its importance

Impact of genetic environment on the development of child : Consider what you learned about the impact of genetics and the environment on the development of the child.

Discuss public health theories : Discuss any public health theories/models that apply to food insecurities. Explain how the theory/model relates to food insecurities, the target population

User Account

All Pages