RDBMS is an acronym for Relational DataBase Management Systems. It's an application that LETS us build, remove, and update relational databases. A relational database is a database system that stores and retrieves data in the FORM of rows and columns in a tabular format. It is a minor subset of DBMS that was created in the 1970s by E.F Codd. The MAJOR DBMS, such as SQL, My-SQL, and ORACLE, are all based on relational DBMS concepts.

The following features are simulated by Relational Database Management Systems to maintain data integrity:

• Entity Integrity: No two records of a database table can be completely duplicated.
• Referential Integrity: Only those rows of those tables that are not used by other tables can be erased. Otherwise, data discrepancy may result.
• User-defined Integrity: Rules based on confidentiality and access that are established by the users.
• Domain integrity: The database tables' columns are contained inside certain specified limits based on default values, data types, or ranges.

The following are the advantages of an RDMS:

• SIMPLE to manage: Each table can be modified independently without impacting the others. It offers logical database independence i.e. data can be viewed in different ways by the different users.
• Secured: It is more secure since it has numerous levels of security. Access to shared data might be restricted.
• Flexible: Data may be updated at a single location without having to make changes to many files. It limits redundancy and replication of the data. Databases can be simply expanded to accommodate additional records, increasing scalability. It also makes it easier to use SQL queries.
• Users: RDBMS can store many users in a client-side architecture.
• Allows enormous amounts of data to be stored and retrieved with ease.
• Simple Data Handling: The relational architecture allows for faster data retrieval. Due to keys, indexes, and normalisation principles, data redundancy or duplication is avoided. Because RDBMS is built on ACID principles for data transactions, data consistency is ensured (Atomicity Consistency Isolation Durability).
• Tolerance for Failures: Database replication allows for simultaneous access and aids in system recovery in the event of disasters such as power outages or unexpected shutdowns.

The following are the disadvantages of an RDMS:

• High Cost and Extensive Hardware and Software Support: To make these systems work, huge budgets and setups are necessary.
• Scalability: As more data is added, more servers, as well as more power and memory, are necessary.
• Complexity: Large amounts of data complicate understanding of RELATIONSHIPS and may reduce performance.
• Structured Limits: A relational database system's fields or columns are surrounded by various limits, which can lead to data loss. It is difficult to recover the lost data.