What Are The Advantages Of Relational Data Model?
Basically, relational databases are based on relational set theory. Normalization is a vital component of relational model of databases. Relational operations, supported by the relational databases work best with normalized tables. A relational database supports relational algebra, consequently supporting the relational operations of the set theory. Apart from mathematical set operations namely, union, intersection, difference and Cartesian product, relational databases also support select, project, relational join and division operations. These operations are unique to relational databases. Relational databases support an important concept of dynamic views. In a relational database, a view is not a part of the physical schema, it is dynamic. Hence changing the data in a table alters the data depicted by the view. Views can subset data, join and simplify multiple relations, dynamically hide the complexity in the data and reduce the data storage requirements. Relational databases use SQ
