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.

Question

Quizplus · Accepted Answer

The Answer is Initially, 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