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:

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.