Database Design & Development Normalisation 1
Quiz
•
Computers
•
University
•
Practice Problem
•
Medium
Nicole Donnelly
Used 4+ times
FREE Resource
Enhance your content in a minute
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main goal of the First Normal Form (1NF) in database normalisation?
To eliminate repetitive groups of data
To ensure referential integrity
To reduce data redundancy
To establish foreign keys
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which form of normalisation is achieved when transitive dependencies are removed?
First Normal Form
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a partial dependency in the context of normalisation?
A dependency on a non-primary key
A dependency involving a candidate key
A dependency on part of a composite key
A dependency on a foreign key
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In which normal form is a table if it contains no transitive dependencies but still has partial dependencies?
1NF
2NF
3NF
4NF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a characteristic of a table in Second Normal Form (2NF)?
It has no transitive dependencies
It has no partial dependencies
It has no duplicated data
It has a primary key
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When is a table considered to be in Third Normal Form (3NF)?
When it is in 2NF and all non-key attributes are mutually independent
When it is in 2NF and there are no transitive dependencies
When it is in 1NF and all attributes are atomic
When it is in 4NF and has no multivalued dependencies
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the term "functional dependency" imply in the context of normalisation?
An attribute uniquely determines another attribute
A table is in 2NF
There are no repeating groups
All attributes are atomic
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
15 questions
2-62_Chap6 Virus Computer Crime
Quiz
•
University
10 questions
Post-Test Creational Design Pattern
Quiz
•
University
15 questions
CHAPTER 4 - PART 1
Quiz
•
University
10 questions
HW7 Chapter 7
Quiz
•
University
10 questions
What is the role of a Disaster Recovery Specialist
Quiz
•
University
10 questions
Sistem Operasi (Manajemen Proses)
Quiz
•
University
10 questions
Computing Software Development Process
Quiz
•
8th Grade - University
10 questions
Cuestionario_Programación
Quiz
•
University
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
