Primary Task Response: Within the Discussion Board area, write 300–500 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
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.