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.