Please answer these questions in 5-6 lines.

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?