Normalization Practice

Frage 1

Frage

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

Image:

3 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 2

Frage

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

Image:

4 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 3

Frage

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)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 4

Frage

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

Image:

6 (binary/octet-stream)

Antworten

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.

Frage 5

Frage

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)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 6

Frage

In which form is the table?

Image:

8 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 7

Frage

In which state are the attributes shown?

Image:

9 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 8

Frage

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

Image:

10 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 9

Frage

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

Image:

11 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 10

Frage

In which state are the attributes shown?

Image:

12 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Frage 11

Frage

In which state is the table above?

Image:

13 (binary/octet-stream)

Antworten

Unnormalized
First Normal Form
Second Normal Form
Third Normal Form

Nächster

Normalization Practice

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

ähnlicher Inhalt

	Erstellt von Craig Willey vor etwa 5 Jahre