A relation Schema R is in ……….. if it is in 3NF and satisfies an additional constant thatfor every FD X->A. X must be a candidate key.

Related MCQs

• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
• Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
• An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called                              
• An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.