ASSIGN_01

HIERARCHICAL VS RELATIONAL

RELATIONAL

Advantages:
* Is to provide a declarative method for specifying data and queries.
* It directly state what information the database contains and what information we want from it.
* The Database management system software can take care of describing data structures for storing the data and retrieval procedures for getting queries answered.
* It have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data and much more.

Dis-Advantages:
* As computer power has increased, the inefficiencies of relational databases, which made them impractical in earlier times, have been outweighed by their ease of use.
* They are much less efficient.

HIERARCHICAL

Advantages:
* The user can identify quickly and understand the information that is being stored in the database due to the design of its structure.
* The information is arranged well in a tree-like structure which makes it the database more efficient to read and understand.
* More common to use.

Dis-Advantages:
* All attributes of a specific record are listed under an entity type and each entity type is equivalent to one table so it is more time consuming compared to Relational.
* You still have to make tables in each parent and children in a structure for you to relate them together.
* It is more complicated rather that Relational which you can understand and much easier to use.