4-16. The Query Corporation employs the individuals listed in Figure 4-19. Use Access or another DBMS required by your i
Posted: Mon May 30, 2022 7:32 am
questions 16 & 18
4-16. The Query Corporation employs the individuals listed in Figure 4-19. Use Access or another DBMS required by your instructor to create a database of this information and then perform the following queries. a. List all employees in Department 5. Print this list. b. List all employees with first name Brenda. Print this list. c. List all those employees with pay rates over $6.50. Print this list. d. List all those employees eligible for overtime (T = yes; F = no). Print this list. 4-17. Use the Web to find current examples of data warehousing software. Why do companies create data warehouses and what are some accounting uses of such warehouses? 4-18. Use the Web to find current examples of online analytical processing (OLAP). Why do companies use OLAP? What is the connection between OLAP and databases? T Tee 1
It's Only needed 4-16. The Query Corporation employs the individuals listed in Figure 4-19. Use Access or another DBMS required by your instructor to create a database of this information and then perform the following queries. a. List all employees in Department 5. Print this list. b. List all employees with first name Brenda. Print this list. c. List all those employees with pay rates over $6.50. Print this list. d. List all those employees eligible for overtime (T = yes; F = no). Print this list. 4-17. Use the Web to find current examples of data warehousing software. Why do companies create data warehouses and what are some accounting uses of such warehouses? 4-18. Use the Web to find current examples of online analytical processing (OLAP). Why do companies use OLAP? What is the connection between OLAP and databases? T Tee 1