Normalization Practice

Question 1

Question

In which state are the attributes shown (see table)?

Image:

3 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 2

Question

In which state is the table in (see table)?

Image:

4 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 3

Question

The primary key in the first table is Booking ID, and the primary key in the second is Client ID. How advanced are the two tables in the normalization process (see tables)?

Image:

5 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 4

Question

What characteristic points to the tables shown above being in third normal form?

Image:

6 (binary/octet-stream)

Answer

The tables are completely free of data redundancy.
“Client ID” appears in more than one table.
Each primary key has a functional dependency on every other primary key in the table.
The attributes are all single valued.

Question 5

Question

The primary key of the table is a composite key made up of Registration ID and Activity ID. In which form is the table?

Image:

7 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 6

Question

In which form is the table?

Image:

8 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 7

Question

In which state are the attributes shown?

Image:

9 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 8

Question

In which state are the attributes shown (see table)?

Image:

10 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 9

Question

In which state are the attributes shown (see table above)?

Image:

11 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 10

Question

In which state are the attributes shown?

Image:

12 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Question 11

Question

In which state is the table above?

Image:

13 (binary/octet-stream)

Answer

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Next up

Normalization Practice

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Similar

	Created by Craig Willey over 5 years ago