INTRODUCTION TO RDBMS

 

Introduction to RDBMS (Relational Database Management System)

In this article, I am going to give you a brief introduction to RDMB (Relational Database Management System). Please read our previous article where we discussed Data Models in DBMS. At the end of this article, you will understand the following pointers in detail.

1. What is DBMS?
2. What is RDBMS?
3. Features of RDBMS
4. Advantages of RDBMS
5. DBMS vs RDBMS
6. E.F. Codd’s Rules

What is DBMS?

DBMS is a software or group of programs designed to perform database operations such as creating a new database, administering and managing the databases by performing various user-specified database operations. The DBMS internally might consist of a group of programs each performing different tasks related to database management. Some DBMS examples, My SQL, Oracle, System 2000, MS Access, My SQL server, etcWhat is 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