18318352
Descripción
Test por Craig Willey, actualizado hace más de 1 año
|
Creado por Craig Willey
hace más de 5 años
|
|
Pregunta 1
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 2
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 3
Pregunta
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)
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 4
Pregunta
What characteristic points to the tables shown above being in third normal form?
Image:
6 (binary/octet-stream)
Respuesta
-
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.
Pregunta 5
Pregunta
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)
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 6
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 7
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 8
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 9
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 10
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
Pregunta 11
Respuesta
-
Unnormalized
-
First Normal Form
-
Second Normal Form
-
Third Normal Form
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.