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.
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.