Distinguish between the following: 'Hierarchical DBMS' and 'relational DBMS'.

CS Professional · Information Technology and Systems Audit · PYQS · December 2015
Distinguish between the following: 'Hierarchical DBMS' and 'relational DBMS'.

Answer & Explanation:

Hierarchical Data Base Management System (HDBMS) A DBMS is said to be hierarchical if the relationships among data in the database are established in such a way that one data item is present as the subordinate of another one or a sub unit i.e. the items have "parent-child" relationships among them. It follows "tree" structure database. No backward movement is allowed in the hierarchical database. Relational Data Base Management System (RDBMS) A DBMS is said to be a Relational DBMS or RDBMS if the database relationships are treated in the form of a table. There are three keys on relational DBMS these are Relation, Domain and Attributes. RDBMS contains a fundamental constructs of sets or records. Sets contain one to many relationships and record statical table contains fields composed of rows and columns. Some popular examples of RDBMS are Oracle, Sybase, Ingress, Informix, Microsoft SQL Server, and Microsoft Access.

Topics: Database Management Systems

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic