The word RDBMS is stands as ‘Relational Database Management System.’ It is represented as a table that contains rows and column.
RDBMS is based on the Relational model; it was introduced by E. F. Codd.
Components of a relational database are :
- Table
- Record/ Tuple
- Field/Column name /Attribute
- Instance
- Schema
- Keys
An RDBMS is a tabular DBMS that maintains the security, integrity, accuracy, and consistency of the data.
All modern database management systems like SQL, MS SQL Server, IBM DB2, ORACLE, My-SQL and Microsoft Access are based on RDBMS.
What is Instances and Scheme ?
The collection of information stored in a database at a particular moments is called an instance of database.
The overall logical structure and design of a database is called as database schema .
Types of Schemas
- Physical Schema
- Logical Schema
- Subschema
