Relational algebra

(1) Relation: A set of tuples. (2) Tuples: A collection of attributes which describe some real world entity. As- student, loan, account table, employee. (3) Attribute: A real-world role played…

Aggregation

Aggregation: Aggregation is process when relation between two or more entity treated as a single entity, where the relation between customer and loan is acting as an entity in relation…

Data dictionary

A relational database system needs to maintain data about the relation such as the schema of the relation. This information is called data dictionary or system catalog or data dictionary…

error: