Relational Model

Represent the database as a collection of relations, with relations pertaining to tables with rows and columns.

• Hierarchical Model

• Network Model

• Object-Oriented Model

• Relational Model

A British scientist who worked for IBM, and invented the relational model for database management.

• Tim Berners-Lee
• Grace Hopper
• Alan Turing
• Edgar F. Codd

Relational Model Concepts:

The properties which define a relation.

• Properties
• Characteristics
• Attributes
• Elements

Relational Model Concepts:

A _ has two properties rows and columns, rows represent records and columns represent attributes.

• table
• list
• file
• database

Relational Model Concepts:
Single row of a table, which contains a single record.

• Tuple
• Record
• Column
• Row

Relational Model Concepts:

Represents the name of the relation with its attributes.

• Relation Schema

• Degree

• Column

• Cardinality

Relational Model Concepts:

The total number of attributes which in the relation.

• Relational Schema

• Tuple
• Degree
• Cardinality

Relational Model Concepts:

Total number of rows present in the Table.

• Relation Schema

• Column

• Degree

• Cardinality

Relational Model Concepts:

Represent the set of values for a specific attribute.

• Relation Schema

• Column

• Degree

• Cardinality

Relational Model Concepts:

A finite set of tuples in the RDBMS system.

• Relation Instances

• Table

• Column

• Relation