Database Normalization - Simple Test

A phrase to describe Un-Normalized Form in Database

• Redundancy

• Primary Key

• Unique

Goals of Database Normalization, except:

• Must Depend on Primary Key

• Eliminate Insertion, Update and Deletion Anomalies

• Minimize Data Redundancy

The following table is in ... form

• 1st Normal

• 3rd Normal

• Un-Normalized

What is the best phrase to describe relationship between table "pembeli" and table "penjualan"?

• One to many

• Many to one

• Undetermined

A relation is in 1NF if it doesn't contain any ...

• Functional dependencies

• Repeating groups

• Null values in primary key fields

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