1. Why is business intelligence so important to an organization?

2. A small but successful business has just started expanding across the country. They are still using their little database in the head office in Vancouver but it is inefficient at processing transactions in real time. What would you recommend that they do?

3. A company in Maple Ridge is getting very busy so they have decided to buy a computer and store their transactions on a database. The owner has managed to set up the database and enter some records but he has no idea how to print out a list of all customers who have purchased their new product called Oak Table N39. You need to explain to him the basic steps on how to do that. Assume the same tables as CA#3, Customer table, Product table, Transaction table and the same fields.

4. The owner in Question #3 above asks you how the three tables were able to be connected by a line. He says that his daughter did that part and she didnt explain how she did it. You explain how this connection between the tables was created.

5. Which of the data manipulation tools of a DBMS was used in Question #3 above?

6. Which data manipulation tool did you not use in Computer Assignment #3?

7. The owner using the database in Question #3 has been struggling to create queries the way you taught him. He asks you if there is an easier way. You tell him that he can hire a programmer to create an easy-to-use menu to easily create queries like the one you taught him. Use the key terms from Chapter 3 to describe this.

8. Your textbook emphasizes that data warehouses are not transaction processing like the database you did for CA#3. However, data warehouses do use operational databases. How is a data warehouse different? Give an example of how a data warehouse can help a business.

9. Which tool discussed in your textbook is the perfect tool for being able to view a data warehouse from various positions and examine specific parts of the data warehouse.