Relational Database Model Components | Database Management System

Relational Database Model Components | Database Management System

Relational Database Model Components: It deals with database management from an abstract point of view. The model provides Specifications of an abstract database management system. The precision is derived from solid theoretical foundation that includes predicate Calculus and theory of relations. To use the database management Systems based on the relational model however, users do not need to master the theoretical foundations.

Codd defined the model as consisting of the following three components:

Relational Data Structure

A Collection of data structure types for building the database. (e.g., relations or tables)

Relational Data Integrity

A Collection of rules that implicitly or explicitly define a consistent database State or changes of States. (e.g., Codd rules)

Relational Data Manipulation

A collection of operators that may be used to retrieve, derive or modify data stored in the data Structures. (e.g., Relational algebra) Let us discuss each of them in detail one by one.