null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
18318352
Normalization Practice
Description
C175
No tags specified
c175 - data management - foundations
college
Quiz by
Craig Willey
, updated more than 1 year ago
More
Less
Created by
Craig Willey
about 5 years ago
3789
1
0
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
Want to create your own
Quizzes
for
free
with GoConqr?
Learn more
.
Similar
Lord of the Flies
lmg719
Epithelial tissue
Morgan Morgan
Biology Unit 1
hannahsanderson1
GCSE Biology Quiz
joannaherbert
Certification Prep_1
Tonya Franklin
GCSE Maths: Algebra & Number Quiz
Andrea Leyden
GCSE Maths Conversions
EmilieT
Chemistry 2
Peter Hoskins
Writing successful GCSE English essays
Sarah Holmes
SFDC App Builder 1 (1-25)
Connie Woolard
A Christmas Carol (Key Quotes)
Samira Choudhury
Browse Library