Design star schema to transform data from transactional

Assignment Help Science

Reference no: EM134020161

Question

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.

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:

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

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

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

Reference no: EM134020161

Questions Cloud

Process of updating policies-procedures varies by facility : Nursing practice should be evidenced-based and the process of updating policies and procedures varies by facility.

Healthcare industry and improved patient outcomes : In what ways has technology revolutionized the healthcare industry and improved patient outcomes?

Antibody deficiency diseases : In a class of antibody deficiency diseases, developing B cells from the bone marrow of several patients were isolated and stimulated through B-cell receptors

Hospitals outpatient high-risk pediatric clinic : Seven-day-old infant was brought by her parents to university hospital's outpatient high-risk pediatric clinic for her first post-hospital discharge examination

Design star schema to transform data from transactional : You will design a star schema to transform data from transactional to analytical for one topic.

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

Culinary characteristics and common ingredients associated : What are main types, culinary characteristics and common ingredients associated with special medical diets that are part of contemporary Australian society

Draw conclusions about sickle cell anemia : Consider how you could use the scientific method to draw conclusions about sickle cell anemia or to treat this disorder.

Explain the health or nursing informatics policy : Explain the health or nursing informatics policy/regulation you selected. Address the impact of the policy or regulation you selected on system implementation.

User Account

All Pages