Overview of RDBMS
Posted in SQL | RDBMS November 27, 2019
This article I will explain about the RDBMS in SQL 2008.
What is RDBMS?
RDBMS stands for Relational Database Management System or Relational DBMS. RDBMS is structured in database tables, fields and records. RDBMS lets you to maintain the data records, data fields in tables. RDBMS are database management systems that create and maintains the relational database. In relational database, tables are used to express relationships between data items.
Relational database model was introduced by Edgar Codd. Relational model consists of following components:
- Collection of objects or relations.
- Set of operations to manipulate tables.
- Data integrity.
In simple words we can say that, RDBMS is a collection of table, and these tables might be related by common table columns. Data stored in these tables can be modified with help of operators provided by RDBMS.
Properties of Relational database
- No duplicate values in rows: each row is unique.
- Column names must not be same: each column is unique.
- Ease the use of
- Example: SQL Server, Oracle etc.