Database Quiz 2 Normalisation
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
W Deng
Used 13+ times
FREE Resource
Enhance your content in a minute
19 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What entity relationship between car and passenger?
Each driver can drive many different cars.
Each car is driven by many different drivers.
one-to-one
one-to-many
many-to-many
2.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
Which of the following is the best statement about normalisation?
It is the process of dividing larger tables into smaller interlinked tables.
Reduces data redundancy.
It is the process of dividing larger tables into smaller independent tables.
It is the process of removing duplicate entries in a table.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which normal form must not contain any repeating attributes &
at an atomic level (no single column contains more than one value) ?
1NF
2NF
3NF
all of above
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What entity relationship between car and passenger?
Each car has one owner, and each owner has one car
(this example assumes that nobody owns multiple cars).
one-to-one
one-to-many
many-to-many
5.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
In which normal form shall we remove non-key attributes that depend on part but not all of the primary key?
1NF
2NF
3NF
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
It is possible to combine attributes to form what is called a _______ key
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
_____ are characteristics or other information about entities
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?
Similar Resources on Wayground
19 questions
Excel 2P-2RVW-Formulas and Functions in Excel
Quiz
•
10th - 12th Grade
20 questions
Semester 1 - Microsoft Word
Quiz
•
9th - 12th Grade
15 questions
Access Basics
Quiz
•
9th - 12th Grade
20 questions
โปรแกรมตารางงาน ทดสอบปลายภาค ชุดที่ 2
Quiz
•
10th - 12th Grade
17 questions
1.4 principles of programming
Quiz
•
6th - 12th Grade
20 questions
Ulangan Harian Teknologi Informasi dan Komunikasi Kelas X
Quiz
•
12th Grade - University
15 questions
Word Lesson 6
Quiz
•
9th - 12th Grade
20 questions
Microsoft Excel - Rows, Columns & Cells
Quiz
•
9th - 12th Grade
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
