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
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
