Computer Science
Assertion. A primary key is used to uniquely identify the rows in a data table.
Reason. A primary key is a field or attribute which has a unique value for each row or tuple.
Relational Database
1 Like
Answer
(a)
Both Assertion and Reason are true and Reason is the correct explanation of Assertion.
Explanation
A primary key is used to uniquely identify the rows in a data table. It is a set of one or more attributes that can uniquely identify tuples (rows) within the relation.
Answered By
2 Likes
Related Questions
Assertion. Data redundancy may lead to data inconsistency.
Reason. When redundant data or the multiple copies of data mismatch, it makes the data inconsistent.
Assertion. Data redundancy may lead to many problems.
Reason. In RDBMS, data redundancy is 100% removed.
Assertion. A data table can have only one primary key.
Reason. In a data table, there can be only one attribute/field containing unique values for each row.
Assertion. There can be multiple options for choosing a primary key in a data table.
Reason. All attribute combinations inside a data table that contain unique values for each row, are the candidate keys.