A hospital is considering building an oncology unit. Discuss what decisions might be supported with business intelligence (BI), and suggest data that might be maintained in the data warehouse (DW). Include the following in your discussion:
List 5 of the major tables that would be included in the DW for oncology patients.
Define index properties, and list the 3 different types.
Explain why null values are required.
Sample Solution