
Database Normalisation
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Moses Balogun
Used 11+ times
FREE Resource
Enhance your content in a minute
37 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Normalisation is:
Removing all necessary data from a database
Organising a database to remove repeated entries and increase the accuracy of the data
Putting fields from different tables into one big database
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following statements fully describes data in 2NF:
When any repeating fields have been removed and the table is given a primary key
When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other
When all the fields in each table are directly related to the primary key
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An advantage of normalisation is:
The storage space needed for a normalised database is likely to be smaller
The process of normalising a database is very easy and doesn’t require any skill
It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is a foreign key?
A unique identifier in a database
A primary key of one table that appears in another table
A field that should not be in a table and needs removing
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Remove any functional dependencies from both relations
Assign both relations the same primary key field(s)
Create a primary key(s) for the new relation
Create a free account and access millions of resources
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?
Similar Resources on Wayground
35 questions
SOAL PSAS Informatika XI.5
Quiz
•
11th Grade - University
35 questions
Quiz Kewirausahaan Teknologi-X TKJ 2
Quiz
•
10th Grade - University
40 questions
Quiz IX
Quiz
•
9th Grade - University
41 questions
KUIS TENTANG JARINGAN
Quiz
•
9th - 12th Grade
35 questions
Computer Parts and Accessories
Quiz
•
7th Grade - Professio...
35 questions
SOAL MATERI CISCO PT 2
Quiz
•
12th Grade
36 questions
CITL3 LO 2 MIX REVIEW
Quiz
•
12th Grade
40 questions
DD - U1 - Intro to Web and Digital Design
Quiz
•
10th - 12th Grade
Popular Resources on Wayground
10 questions
Forest Self-Management
Lesson
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
30 questions
Thanksgiving Trivia
Quiz
•
9th - 12th Grade
30 questions
Thanksgiving Trivia
Quiz
•
6th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
48 questions
The Eagle Way
Quiz
•
6th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
Discover more resources for Computers
30 questions
Thanksgiving Trivia
Quiz
•
9th - 12th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
10 questions
Identifying equations
Quiz
•
KG - University
18 questions
Thanksgiving Trivia
Quiz
•
4th - 12th Grade
20 questions
Thanksgiving
Quiz
•
KG - 12th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
10 questions
hands washing
Quiz
•
5th - 12th Grade
53 questions
US History Domain 1 Review CP 2025 (Tech Enhanced)
Quiz
•
9th - 12th Grade
