Chapter 4

Question 1

First Normal Form

Answer 1

A table is in 1NF if each row is unique and no column in any row contains multiples values

Question 2

Insert Operation

Answer 2

Used for entering new data in the relation

Question 3

Insertion Anomaly

Answer 3

Occurs when inserting data about one real-world entity requires inserting data about another real-world entity

Question 4

Modification Anomaly

Answer 4

Occurs when, in order to modify one real-world value, the same modification has to be made multiple times

Question 5

Normalization

Answer 5

process used to improve the design of relational databases

Question 6

Normal Form

Answer 6

term representing a set of particular conditions (whose purpose is reducing data redundancy data) that a table has to satisfy

• From a lower to higher normal form, these conditions are increasingly stricter and leave less possibility for redundant data

Question 7

Read Operation

Answer 7

data retrieval operation used for reading the data from relations

Question 8

Redundant Data

Answer 8

unnecessarily repeating

Question 9

Update Anomalies

Answer 9

anomalies in relations that contain redundant data, caused by update operations

Question 10

Second Normal Form (2NF)

Answer 10

Normalization of relation 2NF creates additional relations for each set of partial dependencies in a relation

Question 11

Third Normal Form 3NF

Answer 11

A table is in 3NF if it is in 2NF and if it does not contain transitive functional dependencies