Relational database management system

Overview of RDBMS

Definition:

RDBMS stand for Relational Database Management System, A types of database management system (DBMS) that store data in the form of related tables called RDBMS. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.

Characteristics of RDBMS:

The relational data management model eliminated all parent child relationships and instead represented all data in the database as simple row/column tables of data values.

A relation is similar to a table with rows/ columns of data values.

The rows of table are referred to as tuples and columns are referred as attributes.

Each table is an independent entity and there is no physical relationship between tables.

Relational model of database management is based on set theory, built in query language is designed in the RDEMS, so that it can manipulate set of data.

The user interface used with relational models is non procedural because, it only specifies what is to be done and not how it is to be done.

Post a Comment

0 Comments

Ad Code