Assignment 02 - (10 marks)
1.1 What is the purpose of database administration?
1.2 What is the goal of a database security system?
1.3 What is a trigger and how is it used?
1.4 Name three types of triggers.
1.5 What is a stored procedure and how is it used?
1.6 Name the three major components of a Web database application.
1.7 What are the two major functions of a Web server?
1.8 What is IIS and what functions does it serve?
1.9 What is Apache and what functions does it serve?
1.10 What is Hypertext Markup Language (HTML), and what function does it serve?
Assignment 03 – (10 marks)
1.11 What are BI systems?
1.12 How do BI systems differ from transaction processing systems?
1.13 Name and describe the two main categories of BI systems.
1.14 What are the three sources of data for BI systems?
1.15 What problems in operational data create the need to clean data before loading the data into a data warehouse?
1.16 Why are data warehouses necessary?
1.17 Explain the difference between a data warehouse and a data mart. Give an example other than the ones used in this book.
1.18 State the purpose of a reporting system.
Hint:
1.19 What are the major functions of a reporting system?
1.20 Name three tasks of report authoring.
1.21 List the components of a database.
1.22 List specific functions of the DBMS