Question

Which database model allows a child record to have multiple parent records?

• A. Hierarchical model
• B. Network model
• C. Relational model
• D. Flat file model

Hint:

Hierarchical Model = One Parent.
Network Model = Multiple Parents.

Answer 1

The Correct Option is B

Concept: A database model defines the structure and relationships among data elements in a database system. Different models organize data differently depending on the requirements of the application.

Step 1: Understand the Hierarchical Model. The hierarchical database model organizes data in a tree-like structure. In this model:

• One parent can have many children.

• A child can have only one parent.
Therefore, multiple parent relationships are not possible.

Step 2: Understand the Network Model. The network model extends the hierarchical model by allowing:

• Many-to-many relationships.

• Multiple parent records.

• More flexible data structures.
A child record can be linked to more than one parent record.

Step 3: Analyze the remaining options. Relational databases use tables and relationships through keys but the classical answer for multiple-parent records is the network model. Flat file databases contain simple records without complex relationships.

Step 4: Conclusion. Since the network model allows a child record to have multiple parent records, it is the correct answer. Hence, option (B) is correct.