INTRODUCTION TO RDBMS

 INTRODUCTION TO RDBMS

                            RDBMS is the collection of programs and capabilities that enables the user to interact with a relational database. A relational database management system (RDBMS) is a type of DBMS with a row-based table structure. Most commercial RDBMSes use SQL. The most basic RDBMS functions are related to create, read, update and delete operations, collectively known as the CRUD cycle.

Features of RDBMS

• An RDBMS is easily accessible using SQL commands.
• An RDBMS provides full data independence.
• The basic unit of data storage in a relational database is called a table.
• A table consists of tuples/rows/records and each record has one or more columns used to store values.
• In RDBMS, we can use conditional operations such as joins and restrictions.
• An RDBMS enables data sharing between users.
• Also at the same time, you can ensure consistency of data across multiple tables by using integrity constraints.
• An RDBMS minimizes the redundancy of data.