Computer Science
Assertion. All types of keys contain unique values for each row.
Reason. A foreign-key attribute of a table is the primary key of another table.
Relational Database
2 Likes
Answer
(d)
Assertion is false but Reason is true.
Explanation
Not all types of keys necessarily contain unique values for each row. While primary keys ensure uniqueness for each row in a table, other types of keys, such as foreign keys and candidate keys, may not guarantee uniqueness. A non-key attribute, whose values are derived from the primary key of some other table, is known as foreign key in its current table.
Answered By
1 Like
Related Questions
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.
Assertion. The foreign-keys of tables are used to establish relationships with other tables and must be handled carefully.
Reason. Referential integrity is a system of rules that a DBMS uses to ensure that the relationships between tables remain valid and no accidental change or deletion occurs in the related data.
Assertion. A unique value that identifies each row uniquely is the primary key.
Reason. Only one column can be made the primary key.