Database Normalization - Simple Test

Quiz
•
Computers
•
University
•
Medium

IPS IPS
Used 26+ times
FREE Resource
6 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
A phrase to describe Un-Normalized Form in Database
Redundancy
Primary Key
Unique
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Goals of Database Normalization, except:
Must Depend on Primary Key
Eliminate Insertion, Update and Deletion Anomalies
Minimize Data Redundancy
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
The following table is in ... form
1st Normal
3rd Normal
Un-Normalized
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the best phrase to describe relationship between table "pembeli" and table "penjualan"?
One to many
Many to one
Undetermined
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
A relation is in 1NF if it doesn't contain any ...
Functional dependencies
Repeating groups
Null values in primary key fields
6.
MULTIPLE SELECT QUESTION
20 sec • 1 pt
When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Link the relations by a common field
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
Similar Resources on Wayground
10 questions
IMS.

Quiz
•
University
10 questions
DBMS Theory Quiz 2

Quiz
•
University
10 questions
DBMS

Quiz
•
University
10 questions
Database Design_Topic 3_Formative

Quiz
•
University
10 questions
What is the role of a Disaster Recovery Specialist

Quiz
•
University
10 questions
Normalization

Quiz
•
University
10 questions
Normalization

Quiz
•
University
10 questions
Understanding Database Normalisation Concepts

Quiz
•
11th Grade - University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade