
Normalisation
Interactive Video
•
Computers
•
11th Grade
•
Practice Problem
•
Easy
Simon Withey
Used 1+ times
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main focus of this video tutorial?
Exploring data redundancy
Understanding SQL queries
Revisiting database normalization to 3rd normal form
Learning how to create a database
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which rule is violated if the values in a field are not atomic?
Rule 4: No identical records
Rule 3: Atomic values
Rule 2: Values from the same domain
Rule 1: Unique field names
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a partial dependency in the context of 2nd normal form?
A field that is independent of the primary key
A field that depends on part of the primary key
A field that is dependent on another field
A field that depends on the entire primary key
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a transitive dependency?
A field that is independent of all other fields
A field that depends on multiple fields
A field that depends on another field, which in turn depends on the primary key
A field that depends on the primary key
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of separating the mark field into its own table?
To reduce data redundancy
To remove transitive dependencies
To simplify the database structure
To increase data redundancy
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade