the same time and still manages to maintain the data consistency. .Query Language RDBMS provides users with a simple query language, using which data can be easily fetched, inserted, deleted and updated in a database. . Security The RDBMS also takes care of the security of data, protecting the data from unauthorized access.
In a typical RDBMS, we can create user accounts with different access permissions, using which we can easily secure our data by restricting user access. . DBMS Supports Transactions It allows us to better handle and manage data integrity in real world applications where multi-threading is extensively used. .
. Advantages of RDBMS • Segregation of application program • Minimal data duplication or Data Redundancy • Easy retrieval of data using the Query Language • Reduced development time and maintenance 12th Computer Chapter - - . . Components of DBMS The Database Management System can be divided into five major components as follows: .Hardware .Software .Data .Procedures/Methods .Database Access Languages Hardware Software Data Base Access Languages Components of DBMS USER Procedures / Methods DATA Figure .
. Hardware: The computer, hard disk, I/O channels for data, and any other physical component involved in storage of data . Software: This main component is a program that controls everything. The DBMS software is capable of understanding the Database Access Languages and interprets into database commands for execution.
. Data: It is the resource for which DBMS is designed. DBMS creation is to store and utilize data. .
Procedures/Methods: They are general instructions to use a database management system such as installation of DBMS, manage databases to take backups, report generation, etc. . DataBase Access Languages: They are the languages used to write commands to access, insert, update and delete data stored in any database. Examples of popular DBMS: Dbase, FoxPro Database Structure .
Table is the entire collection of related data in one table, referred to as a File or Table where the data is organized as row and column. Each row in a table represents a record, which is a set of data for each database