Question

Match List-I with List-II

Choose the correct answer from the options given below:

• (A) - (II), (B) - (I), (C) - (III), (D) - (IV)
• (A) - (IV), (B) - (III), (C) - (I), (D) - (II)
• (A) - (I), (B) - (II), (C) - (IV), (D) - (III)
• (A) - (III), (B) - (IV), (C) - (I), (D) - (II)

Hint:

To solve database matching questions quickly:
Relational $\rightarrow$ Tables linked by Foreign keys.
Object-oriented $\rightarrow$ Organized by Classes and Attributes.
Hierarchical $\rightarrow$ Tree structure of Parent-Child relationships.

Answer 1

The Correct Option is D

Step 1: Understanding the Concept:
Database Management Systems (DBMS) organize, store, and retrieve data using distinct structural frameworks known as database models.
Each model has a unique way of representing data and the relationships between different data entities.
These include traditional hierarchical and network models, as well as modern relational and object-oriented models.

Step 2: Detailed Explanation:
Let us analyze and match each database model with its characteristic component:
(A). Relational Database Model \(\rightarrow\) (III) Foreign key:
The relational model organizes data into tables (relations) consisting of rows and columns.
Relationships between tables are established using keys.
A Foreign Key is a column in one table that points to the primary key of another table, linking the data between them.
Thus, (A) matches with (III).
(B). Object-Oriented Database Model \(\rightarrow\) (IV) Attribute and Class:
The object-oriented model represents data as objects, similar to object-oriented programming.
It groups objects with similar properties and behaviors into a Class, and their individual properties are represented as Attributes.
Thus, (B) matches with (IV).
(C). Network Database Model \(\rightarrow\) (I) One-to-Many relationship:
The network model represents data as a graph where records are nodes and relationships are edges.
It supports complex relationships, but its basic structural unit is the “set,” which defines a One-to-Many relationship between an owner record and member records.
Thus, (C) matches with (I).
(D). Hierarchical Database Model \(\rightarrow\) (II) Child and parent tables:
The hierarchical model organizes data in a tree-like structure, similar to an organizational chart.
Relationships are structured as a series of Parent and Child tables, where each child record can have only one parent record.
Thus, (D) matches with (II).
Combining these pairings: (A) - (III), (B) - (IV), (C) - (I), (D) - (II), which corresponds to option (D).

Step 3: Final Answer:
Therefore, the correct match is represented by option (D).