Copiar e Editar

Normalization Practice

Descrição

C175
Craig Willey
Quiz por Craig Willey, atualizado more than 1 year ago
Craig Willey
Criado por Craig Willey aproximadamente 5 anos atrás
3789
1
0

Resumo de Recurso

Questão 1

Questão
In which state are the attributes shown (see table)?
Image:
3 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 2

Questão
In which state is the table in (see table)?
Image:
4 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 3

Questão
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)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 4

Questão
What characteristic points to the tables shown above being in third normal form?
Image:
6 (binary/octet-stream)
Responda
  • 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.

Questão 5

Questão
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)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 6

Questão
In which form is the table?
Image:
8 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 7

Questão
In which state are the attributes shown?
Image:
9 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 8

Questão
In which state are the attributes shown (see table)?
Image:
10 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 9

Questão
In which state are the attributes shown (see table above)?
Image:
11 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 10

Questão
In which state are the attributes shown?
Image:
12 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Questão 11

Questão
In which state is the table above?
Image:
13 (binary/octet-stream)
Responda
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Português concurso
Roberta Souza
Biosfera
joana_pinto_202
Noções de organização administrativa- - centralização, descentralização, concentração e desconcentração - adm direta e indireta - autarquias , fundações, empresas publicas, sem
michelegraca
Doenças Cardiovasculares
marianamota99
Garantias Fundamentais
Wander
GESTAO ESTRATÉGICA DE RH
Matheus Miranda
Artigo Pós-Graduação
c.macanhan
Sistema Endócrino
Gabriel Paes
Questões Grécia Antiga- Antiguidade Classica
vesanso Souza
ÁRVORE DOS SONHOS_UCBV
SBMS SBMS
Art. 5º da CF/88
Luís Felipe Mesiano
Explore a Biblioteca