Copy and Edit

Normalization Practice

Description

C175
Craig Willey
Quiz by Craig Willey, updated more than 1 year ago
Craig Willey
Created by Craig Willey almost 6 years ago
6691
2
0
1 2 3 4 5 (1)

Resource summary

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
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Germany 1918-34
evie.challis
Direito ambiental
Luiz Ricardo Oliveira
Cell Structure
megan.radcliffe16
Coastal Landscapes
Chima Power
How does Shakespeare present villainy in Macbeth?
maxine.canvin
Working memory model
T W
B2, C2, P2
George Moores
English / FRUIT
Jan Laxckey
Population growth and structure
chlopandactyl
AAHI_Card set 9 (Prefixes)
Tafe Teachers SB
Browse Library