Question 26
An attribute that is part of at least one candidate key is called a -
A prime attribute belongs to at least one candidate key; an attribute not belonging to any candidate key is non-prime.
An attribute that is part of at least one candidate key is called a -
A prime attribute belongs to at least one candidate key; an attribute not belonging to any candidate key is non-prime.
A superkey is a set of attributes that -
A superkey functionally determines all attributes of the relation and therefore uniquely identifies each tuple.
A foreign key in one relation generally references a -
Referential integrity requires foreign-key values to match a candidate key value in the referenced relation, subject to NULL rules.
If a relation has no candidate key containing fewer attributes than a given candidate key, that candidate key is -
Minimality means no proper subset of the key can uniquely identify tuples.
Which constraint prevents duplicate values in a column or a specified group of columns?
A UNIQUE constraint enforces uniqueness over the constrained column or column combination; NULL handling can vary by DBMS.