DBMS- NORMALIZATION

A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.

• Dependent

• Normal

• Candidate

• Both Normal and Candidate

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

• A -> B

• A -> C

• A -> (B,C)

• (B,C) -> A

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

• Transitive Dependency

• Insertion Anomaly

• Referential Integrity Constraint

• Normal Form

Every constraint on the table is a logical consequence of the table’s

• Fourth normal form

• Fifth normal form

• Domain/key normal form

• None of the Mentioned

In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.

• Candidate

• Join

• Functional

• None of the Mentioned

Anomalies are avoided by splitting the offending relation into multiple relations, is also known as

• Accupressure

• Decomposition

• Precomposition

• Both Decomposition and Precomposition

A ___ is normalized after it has been organized.

• 1. Table

• 1. Database

• 1. Row

• 1. Column

A common approach to normalization is to ___ the larger table into smaller tables and link them together by using relationships.

• 1. Add

• 1. Subtract

• 1. Multiply

• 1. Divide

In practical applications, how many types of Normal Forms are there?

• 3

• 4

• 5

• 6

When a relation is in 2NF and there is ___, it is in 3NF.

• 1. Transition Dependency

• 1. No Transition Dependency

• 1. Relational Dependency

• 1. No Relational Dependency