Database Design & Development Normalisation 1

Quiz
•
Computers
•
University
•
Medium

Nicole Donnelly
Used 2+ times
FREE Resource
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
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Gantt Chart

Quiz
•
University
10 questions
dbms lab quiz

Quiz
•
University
10 questions
ROUND 4

Quiz
•
University
10 questions
๊แบบทดสอบ UML

Quiz
•
University
10 questions
Behavioral Design Patterns

Quiz
•
University
15 questions
2425 S5 ICT Lesson Quiz - DB Normalization

Quiz
•
11th Grade - University
13 questions
BT2102 Tutorial 3

Quiz
•
University
10 questions
DBMS Theory Quiz 2

Quiz
•
University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Would you rather...

Quiz
•
KG - University
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)

Quiz
•
8th Grade - University
7 questions
Force and Motion

Interactive video
•
4th Grade - University
10 questions
The Constitution, the Articles, and Federalism Crash Course US History

Interactive video
•
11th Grade - University
7 questions
Figurative Language: Idioms, Similes, and Metaphors

Interactive video
•
4th Grade - University
20 questions
Levels of Measurements

Quiz
•
11th Grade - University
16 questions
Water Modeling Activity

Lesson
•
11th Grade - University
10 questions
ACT English prep

Quiz
•
9th Grade - University