The Relational and CODASYL models are examples of two different approaches by which a Database Management System will be classified. Make a detailed comparison of each of these models, indicating clearly the relative advantages and disadvantages of each.

Question

Quizplus · Accepted Answer

The Answer is CODASYL
- records in chains/rings
- parent-child links
- many parents for a child
- ordering of all records
- fixed access paths
- potential for automatic referential integrity.
Relational
- set of tables (as perceived by users)
- rows/columns
- variety of possible storage structures
- no repeating groups
- no links/pointers
- use of join columns.
CODASYL Data Model Advantages
- longevity and availability of DBMSs for this model
- all data relationships can be modeled
- standards exist
- good performance
- data independence.
CODASYL Data Model Disadvantages
- complex navigation
- complexity.
Relational Data Model Advantages
- simplicity
- high level of data independence
- strong theoretical foundation.
Relational Data Model Disadvantages
- performance needs improvement
- referential integrity not supported.

The Relational and CODASYL Models Are Examples of Two Different