Full Form of RDBMS
Relational Database Management System
RDBMS Full Form is Relational Database Management System. RDBMS is a type of database management system that stores data in the form of related tables. The data in RDBMS is stored in the form a cluster of tables related by some common fields.
RDBMS was invented by E. F. Codd of San Jose Research Laboratory. It is a relational model to collect and process data. Relational databases are powerful since they use few assumptions about how the data is related and how it can extract from a database. An important feature of RDBMS is that a one can spread a single database across numerous tables. In RDBMS data are arranged in database tables, fields, and records.
The RDBMS table consists of database table rows and the database table row consists of one or more database table fields. Commercial RDBMS uses the Structured Query Language (SQL) to operate and access the database. However, SQL was invented after RDBMS & is not compulsorily required to use SQL. Oracle, SQL Server, DB2, Informix, MYSQL etc. are some of the leading RDMS products. In each RDBMS, there exists data integrity. Data integrity is categorized as the following:
- Entity Integrity: There must be no duplicate rows in a table
- Domain Integrity: Valid entries for a given column are must by restricting the type or range of values
- Referential integrity: Does not allow deletion of Rows used for other records
- User-Defined Integrity: Consists of some rules that’s doesn’t fall in either of three categories described earlier.