A relation that has no partial dependencies is in which normal form

Related MCQs

• Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
• 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
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
• A relation is in this form if it is in BCNF and has no multivalued dependencies:
• A relation is in this form if it is in BCNF and has no multivalued dependencies:
• The normal form which satisfies multivalued dependencies and which is in BCNF is
• Which of the normal form is based on multivalued dependencies?
• 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                              
• 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 ______________