Relational Database Management System involves all modern database management systems like SQL, MS SQL Server, IBM DB2, ORACLE, My-SQL and Microsoft Access are based on RDBMS. It is called Relational Database Management System (RDBMS) because it is based on relational model introduced by E.F. Codd.
What is Relational Database?
A relational database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Often, data in a relational database is organized into tables.
Table
A table is a collection of related data entries and contains rows and columns to store data. A table is the simplest example of data storage in RDBMS.
| ID | NAME | Gender | Age | Course | Branch |
| 1. | Aniket | Male | 23 | MBA | Marketing |
| 2. | Ravi | Male | 20 | B.Sc. | Biology |
| 3. | Sheetal | Female | 19 | B.A. | English |
| 4. | Lavish | Male | 22 | MBA | Finance |
Here, Fields are ID, NAME, Gender, Age, Course, Branch.
And, rest are Records.
RDBMS Applications
- Oracle Database
- MySQL
- Microsoft SQL Server
- IBM DB2
Data Integrity
- Entity integrity: It specifies that there should be no duplicate rows in a table.
- Domain integrity: It enforces valid entries for a given column by restricting the type, the format, or the range of values.
- Referential integrity: It specifies that rows cannot be deleted, which are used by other records.
- User-defined integrity: It enforces some specific business rules that are defined by users. These rules are different from entity, domain or referential integrity.
Summary
Relational databases store data in the form of tables. Tables can grow large and have a multitude of columns and records. Relational database management systems (RDBMSs) use SQL (and variants of SQL) to manage the data in these large tables. The RDBMS you use is your choice and depends on the complexity of your application.
