132k views
0 votes
Discuss the capabilities that should be provided by a DBMS.

1 Answer

7 votes

Answer:

They include;

1. A database backup and recovery system.

2. A good security architecture

3. Concurrent access to the system

4. Data dictionary

5. Data definition

6. Data Manipulation Language

Step-by-step explanation:

A Database Management system shortened as DBMS is used in the organization, storage, and retrieval of data and files in a database. It makes working with files easy and curbs the duplications that can arise from working with files. The capabilities that should be provided by the DBMS include;

1. A database backup and recovery system: There should be a provision for files to be backed up so as to ease their recovery when lost.

2. A good security architecture: This helps to ensure that only authorized users can get access to files. Integrity is also assured this way.

3. Concurrent access to the system: Multiple users should be able to access files at the same time.

4. Data Dictionary: This is a file that helps in the storage of information on the data in the database.

5. Data Definition: This would ensure that the structure of data is properly spelled out.

6. Data Manipulation Language: such as Sequence Query Language is a programmed language that is used in working on data and files.

Examples of DBMS software include:

MySQL, Microsoft Access, Oracle, PostgreSQL, dBase, FoxPro, etc

User Jake Burton
by
5.0k points