solution

The owner of a small business is learning how to use a database to keep track of his company’s sales. He asks you which database tool would allow him to format the output of sales transactions to show the total sales for each customer.

4. The owner in question 3 above would also like to be able to display on the screen the weekly sales transactions for one specific product. Which database tool would you tell him to use?

5. The owner in question 3 wants to allow some of his staff to be able to access and make changes to the database but since the computer is not in a secure room he is concerned about controlling who has access to the database. Which facilities are available in a database that would allow the owner to do this?