Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?
A)network database
B)hierarchical database
C)object-oriented database
D)cluster database

Question

Quizplus · Accepted Answer

Hierarchical database is designed to represent one-to-many relationships between a parent and its children. However, it is not efficient for handling many-to-many relationships as it requires redundancy and leads to data inconsistency. Therefore, option B is the correct choice. A network database and an object-oriented database both can handle one-to-many as well as many-to-many relationships efficiently. A cluster database is used for distributed systems and does not relate to the question.

Which of the Following Database Architectures Works Well for One-To-Many