Which of the following is a major limitation of the hierarchical database model?

Options

  • A. It does not support parent-child relationships
  • B. It does not support complex many-to-many relationships naturally
  • C. It cannot store records
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. It does not support complex many-to-many relationships naturally

Detailed Explanation

  • Hierarchical model limitation: It naturally supports one-to-many relationships.
  • Many-to-many relationships are difficult to represent directly.
  • Such relationships may require duplication or additional structures.