Building a Data Warehouse
Number of sources: 4
Primary Task Response: Within the Discussion Board area, write 600 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.
Expressions and Functions
An expression can consist of up to 4 different elements. Complete the following:
â€¢ Name and explain the 4 elements.
â€¢ List the 7 arithmetic operations.
Note: Please cite references using the APA format (references used must be published within the last 5 years. Also, please ensure you are creating a title for each questions that are answered.