Database Normalization - Simple Test

Database Normalization - Simple Test

University

6 Qs

quiz-placeholder

Similar activities

Databases and Information Management

Databases and Information Management

University

10 Qs

IMS.

IMS.

University

10 Qs

Chapter 7: Database

Chapter 7: Database

University

10 Qs

Normalization

Normalization

University

10 Qs

Normalization

Normalization

University

10 Qs

Database Management System

Database Management System

University

9 Qs

DBMS concepts(Hard)

DBMS concepts(Hard)

University

10 Qs

Understanding Database Normalisation Concepts

Understanding Database Normalisation Concepts

11th Grade - University

10 Qs

Database Normalization - Simple Test

Database Normalization - Simple Test

Assessment

Quiz

Computers

University

Medium

Created by

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

Media Image

The following table is in ... form

1st Normal

3rd Normal

Un-Normalized

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image

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