Match the following formal relational terms with their informal equivalents.…
2021
Match the following formal relational terms with their informal equivalents.
Column I (Formal terms)
i. Relation
ii. Tuple
iii. Domain
iv. Attribute
Column II (Informal equivalents)
1. Row
2. Column
3. Table
4. Set of permitted values for an attribute
- A.
i-3, ii-4, iii-1, iv-2
- B.
i-3, ii-1, iii-4, iv-2
- C.
i-1, ii-3, iii-2, iv-4
- D.
i-4, ii-3, iii-2, iv-1
Attempted by 2162 students.
Show answer & explanation
Correct answer: B
The visible matching lists are:
Column I: i. Relation, ii. Tuple, iii. Domain, iv. Attribute
Column II: 1. Row, 2. Column, 3. Table, 4. Set of permitted values for an attribute
Relation is represented informally as a table, so i-3.
Tuple means a row in a relation, so ii-1.
Domain is the set of permitted values for an attribute, so iii-4.
Attribute means a column in a relation, so iv-2.
Therefore, the correct matching is i-3, ii-1, iii-4, iv-2. Hence, Option B is correct.