Features of a DBMS

Data Definition & Data Manipulation

DBMS provides a means to structure data as records, tables or objects. The structure will be defined by considering the type, size of the fields and constraints to be satisfied for each field, accept data from the input operators, and stored for later retrieval. Inserting, updating and deleting will be handled at the data manipulation process.

Data Security and Integrity

This will provide multi-user access to data by ensuring security so that users will be prevented from viewing or changing certain types of information.Database integrity is maintained by not allowing more than one user to update the same record at the same time.

Data Recovery & Performance Maintenance

This provides a mechanism to recover data due to a system failure. Optimizing the performance of the query process is one of the important features of DBMS.

Data Dictionary Maintenance

Data dictionary (metadata) describes and maintains the structure of the database, related files, and records information.