UNIT IV Normalization

Quiz
•
Computers
•
University
•
Hard

Gincy Abraham
Used 36+ times
FREE Resource
20 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
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
3.
MULTIPLE CHOICE QUESTION
30 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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A table in ____ contains no transitive dependencies.
1NF
2NF
3NF
none of the above
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When is a table is said to be 3NF
Normalization improves performance by reducing redundancy.
If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key
It involves introduction of redundancy in data
None of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Identify the types of Data Anomalies:
Add, Delete and Save anomalies
Insert, Add and Save anomalies
Update, Save and Insert anomalies
Insert, Delete and Update anomalies
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Which is the best example of a Primary Key?
Price
Name
Address
IC No
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Types of Programming Languages - Quiz

Quiz
•
University
16 questions
Normalization CS

Quiz
•
12th Grade - University
20 questions
DBMS Relational Algebra & Calculus Quiz 4

Quiz
•
University
25 questions
Ôn thi cuối kỳ Công nghệ phần mềm

Quiz
•
University
20 questions
Database Architecture

Quiz
•
University
16 questions
REACT JS

Quiz
•
University
15 questions
Chapt.6 - Normalization

Quiz
•
University
15 questions
ER MODEL

Quiz
•
University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)

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

Interactive video
•
4th Grade - University
36 questions
Unit 5 Key Terms

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

Interactive video
•
4th Grade - University
15 questions
Properties of Equality

Quiz
•
8th Grade - University
38 questions
WH - Unit 3 Exam Review*

Quiz
•
10th Grade - University
21 questions
Advise vs. Advice

Quiz
•
6th Grade - University
12 questions
Reading a ruler!

Quiz
•
9th Grade - University