Guide IV
Chapter 2 Database Environment
2.1 Discuss the reasons for the three-level architecture for a Database Management System.
2.2 Security and recovery are two important functions of a Database Management System, which are
also of interest to Database Administration. Various facilities can be provided to aid both these
functions. Explain what these facilities are and with examples, show how Database
Administration could effectively use them.
The examples should be given using the current DBMS that is in use. The focus is on security and
2.3 Explain the purpose of the ANSI/SPARC three-level architecture for a Database Management
System, and describe its function giving examples to illustrate your points. Detail the components
of a Database Management System, explaining in particular the specific functions of the software
modules.
2.4 A database management system provides a number of facilities, which will vary from system to
system. Describe the type of facilities you might expect, especially those that aid the initial
implementation of a database and its subsequent administration.