Chat with AIExam 1: Introduction to Databases and Database Environment
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.
(43) 
VerifiedThe examples should be given using the current DBMS that is in use. The focus is on security and recovery. Security may include authorization mechanisms and associated granting of access privileges. Views and encryption procedures may also be described. These mechanisms should be elaborated. Recovery functions include backup procedures and safe storage of the media, journaling and checkpointing, and the recovery manager. The database administration role should be linked to their use.
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.
(30) VerifiedThe answer to the first part of this question is similar to that for 2.1. This question specifically asks for examples to be used, and these should be present in a full answer.
To answer the second part of the question, a diagram would be useful. It may show the whole environment - users, DBMS software (expanded), data, and implicit hardware. The emphasis is on the DBMS modules, which need to be explained. These include DML precompiler, Query processor, DDL compiler, Database manager, and Data dictionary. The explanation should include how modules interact with others.
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.
(29) VerifiedInitially, the type of facilities expected should be described. These include: data storage and retrieval, concurrency control mechanism, authorization services, integrity mechanisms, and transaction support. The focus is then on facilities such as data definition, which is stored in the catalog, authorization control to manage the users. View definition, transaction support and integrity controls also aid subsequent administration.
A database management system provides a number of facilities that 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.
(35) Applications built around file management systems have often been used to satisfy user requirements. Discuss the problems that arise with such systems, and what advantages a database management system could offer instead.
(31) Discuss the problems that arise when organizations rely upon multiple computerized file systems to store data. Discuss the advantages and disadvantages in using a database management system to carry out the same functions.
(38) Explain what is meant by a database management system, and contrast it with a File Management System.Give a full account of the type of system structure you might expect for a Database Management System, and outline the type of facilities such a system should provide. If you were in the position of appraising an application for possible implementation using a Database Management System, what aspects of the application would you consider with respect to the advice you might give?
(30) Discuss the reasons for the three-level architecture for a Database Management System.
(39) 
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)