Normalization

Question 1

A technique for producing a set of relations with desirable properties, given the data requirements of an enterprise.

Answer 1

Normalization

Question 2

occurs when a user who wants to insert data about one real-world entity is forced to enter data about another real-world entity.

Answer 2

Insertion anomaly

Question 3

occurs when a user who wants to delete data about a real-world entity is forced to delete data about another real-world entity.

Answer 3

Deletion anomaly

Question 4

occurs when, in order to modify one value, the same modification has to be made multiple times.

Answer 4

Modification anomaly

Question 5

The sets of rules to eliminate
anomalies, and produce a new
collection of problem-free tables.

Answer 5

Normal forms

Question 6

Types of Normal Forms

Answer 6

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
• Boyce-Codd Normal Form (BCNF)
  Normalization
• Fourth Normal Form (4NF)
• Fifth Normal Form (5NF)
• Domain Key Normal Form (DKNF)

Question 7

Describes the relationship between
attributes in a relation.

Answer 7

Functional dependency

Question 8

An attribute or collection of attributes whose values determine the values of another attribute.

Answer 8

determinant

Question 9

Indicates that if A and B are attributes of a relation, B is fully functionally dependent on A if B is functionally dependent on
A, but not on any proper subset of
A.

Answer 9

Full Functional Dependency

Question 10

A condition where A, B and C are attributes of a relation such that A -> B and B -> C, then C is transitively dependent on A via B (provided that A is not functionally dependent on B or C).

Answer 10

Transitive Dependency

Question 11

A table or relation is in ________ if it contains a repeating group.

Answer 11

Unnormalized Form

Question 12

An attribute or group of attributes within a table that occurs with multiple values for a single occurrence of the nominated key attribute(s) for that table.

Answer 12

Repeating Group

Question 13

A table or relation is in ________ if it does not contain repeating groups.

Answer 13

First Normal Form

Question 14

A table or relation is in _________ if it is in 1NF and every non-key attribute is fully functionally dependent on the primary key (no partial dependencies).

Answer 14

Second Normal Form

Question 15

A table or relation is in ____________ if it is in 2NF and no non-key attribute is transitively
dependent on the primary key.

Answer 15

Third Normal Form

Question 16

An attribute or collection of
attributes that has all the required
characteristics of a primary key.

Answer 16

Candidate key

Question 17

A table or relation is in __________ if and only if every determinant is a candidate key.

Answer 17

Boyce-Codd Normal Form