Capabilities of a database management system
The database management system is software support for the business organization for storing and retrieving organizational data appropriately. Capabilities of a database management system are as follows:
- The database management system is used for organizing, managing and accessing the organizational database
- It specifies data definition language, data dictionary, and data manipulation
- It can share organizational information
- It ensures quick access to information
- It increases data productivity
- It reduces storage spaces
The relational database can be so powerful because of the following reasons:
- Relational database management system records database in a structural format using rows and columns to make data more clear and transparent
- It uses an algorithm to analyze the concurrent user access to the organizational database
- It helps in automating data and provides data backup
- It monitors database activity
Examples of relational database systems are-Oracle database, MySQL, and Microsoft SQL Server.