Normalization

Question 1

a process of organizing data to minimize data redundancy, a series of steps taken to remove redundancy and update anomalies in database design.

Answer 1

Normalization

Question 2

It main objective is to create an accurate
representation of data, its relationship, and constraints.

Answer 2

Purpose of Normalization

Question 3

Facilitate the ______ and ______________ of data to users and applications that make use of the databases

Answer 3

access and interpretation

Question 4

Goal #1

TWO MAIN GOALS OF NORMALIZATION

Answer 4

Eliminate redundancy of data.

Question 5

Goal #2

TWO MAIN GOALS OF NORMALIZATION

Answer 5

Eliminate insert, delete, and
update anomalies.

Question 6

disallowing multivalued attributes

three main rules for normalizing data

Answer 6

Eliminate repeating data

Question 7

no column in the table can be related only to a part of the primary key

three main rules for normalizing data

Answer 7

Eliminate partial dependencies

Question 8

a column in the table refers to a non-key column instead of referring to the primary key of a table.

three main rules for normalizing data

Answer 8

Eliminate transitive dependencies

Question 9

It describes the relationship between
attributes (column) in a table.

Answer 9

Functional Dependency

Question 10

• An attribute or a group of attributes
  on the left-hand side of the arrow of a
  functional dependency

Functional Dependency

Answer 10

determinant

Question 11

B is functionally dependent on A but not on any proper subsets of A

Functional Dependency

A and B are attributes (columns) in a table

Answer 11

Full Functional Dependency

Question 12

Some attributes can be removed from A but the dependency still holds.

Functional Dependency

A and B are attributes (columns) in a table

Answer 12

Partial Functional Dependency

Question 13

if A is functionally dependent on B, and B is functionally dependent on C and C is ________ dependent on A via B.

Functional Dependency

A, B and C are attributes (columns) in a table

Answer 13

Transitive Functional Dependency

Question 14

A table that consists of one or more repeating groups.

Process of Normalization

Answer 14

Unnormalized Form

Question 15

the domain of an attribute must include only atomic values and that the value of any attribute in a tuple must be a single value from the domain of that attribute.

Process of Normalization

Answer 15

First Normal Form (1NF)

Question 16

It is in this form IF and only IF it is in 1NF and every non-key attribute is fully dependent on the primary key.

Process of Normalization

It is accomplished by eliminating partial dependencies.

Answer 16

Second Normal Form (1NF)

Question 17

It is in this for IF and only IF it is in 2NF and every non-key attribute is nontransitively (or directly) dependent on the primary key.

Process of Normalization

Answer 17

Third Normal Form (1NF)

Question 18

a slightly stronger version of the third normal form. It handles a problem with an entity that might have two primary keys.

Process of Normalization: Higher Level of Normal Forms

Answer 18

The Boyce-Codd Normal Form (BCNF)

Question 19

It is in this form IF and only IF every join dependency in the relation is a consequence of the candidate keys of the relation

Process of Normalization: Higher Level of Normal Forms

also called the projection-join normal form (PJ/NF).

Answer 19

The Fifth Normal Form (5NF)

Question 20

a key that uniquely identifies rows in a table. It can be a combination of attributes that can be
uniquely used to identify a database record without any extraneous data.

Answer 20

candidate key

Question 21

This normal form was named after Ray Boyce who was one of the creators of SQL, and Edgar Codd
who is the father of relational databases.

Answer 21

The Boyce-Codd Normal Form (BCNF)

Question 22

It eliminates most of the anomalies known in databases today, and it is the most common
standard for normalization in commercial databases and computer-aided software engineering
tools.

Answer 22

The Boyce-Codd Normal Form (BCNF)

Question 23

Correct duplicate ____ and database _________

Answer 23

data, anomalies

Question 24

Avoid ________ and ________ any unwanted data connections and dependencies.

Answer 24

creating and updating

Question 25

Prevent ________ ________ of data.

Answer 25

unwanted deletion

Question 26

________ storage space.

Answer 26

Optimize

Question 27

Reduce the _____ and __________ of checking databases when new types of data need to be introduced.

Answer 27

delay and complexity