Data Definition and Integrity Constraints in Hierarchal Database Model

In this tutorial, we are going to learn about the data definition and integrity constraints in Hierarchal database model of DBMS.
Submitted by Anushree Goswami, on June 10, 2019

Hierarchical database model

In the database management system, a Hierarchical database model is a data model in which data are organized in a way of tree-like structure. The data in the database are stored in the form of records and are further connected through links to each other.

Hierarchical database model

Image source:

Whenever we talk about Hierarchical schema, a number of built-in inherent constraints exist in Hierarchical database model. Following are the given constraints:

  1. In the hierarchical data model, except the root records, no other record occurrences exist unless it is being related to a parent record occurrence. This has the following implications:
    1. No child record can be inserted unless it is linked to a parent record.
    2. One can easily delete child record independently from the model but if the parent record is deleted, then the child record will get deleted automatically and descendent records.
    3. Above rules do not apply to the virtual child records and virtual parent records.
  2. The child record must be duplicated once under every parent record if a child record has two or more parent records from the same record type.
  3. The above task can be performed by a child record having two or more parent records of different record types among which at most one parent record should be real and the other all parent records are virtual parents. Information Management System (a database and transaction management system) limits the number of virtual parents to one.
  4. A record type can be the virtual parent in only one VPCR type in IMS. That means the number of virtual children records can only be one in per record type in IMS.

Related Tutorials


Comments and Discussions!

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© some rights reserved.