The most widely used model by commercial data processing applications. It uses a collection of tables to represent data and the relationships among those data.
Data is stored in tables called relations. Each table is a group of columns and rows, where columns represent attributes of an entity and rows represent records (or tuples).
Attribute or Field: Each column in a relation is called an attribute. The values of the attribute should be from the same domain.
Example: Attributes of a student might include Student-ID, Student-Name, and Student-Age.
Tuple or Record: Each row in the relation is called a tuple. A tuple defines a collection of attribute values, so each row in a relation contains unique values.
Example: Each row contains all the information about a specific individual, like a row for student Ashish.
This model was initially described by Edgar F. Codd in 1969.
RDBMS stands for Relational Database Management System. An RDBMS is a DBMS based on the relational model introduced by E.F. Codd. It is the basis for SQL and modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
