Normalization : The process of organizing the data in the database

This sets of MCQs helps you to understand about the process of Normalization, the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.

Start Quiz

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

A → B. A → C. A → (B,C). (B,C) → A.

In the __________ normal form, a composite attribute is converted to individual attributes.

First Second Third Fourth

A table on the many side of a one to many or many to many relationship must:

Be in Second Normal Form (2NF) Be in Third Normal Form (3NF) Have a single attribute key Have a composite key

Tables in second normal form (2NF):

Eliminate all hidden dependencies Eliminate the possibility of a insertion anomalies Have a composite key Have all non key fields depend on the whole primary key

Which-one ofthe following statements about normal forms is FALSE?

BCNF is stricter than 3 NF Lossless, dependency -preserving decomposition into 3 NF is always possible Loss less, dependency – preserving decomposition into BCNF is always possible Any relation with two attributes is BCNF

Functional Dependencies are the types of constraints that are based on______

Key Key revisited Superset key None of the mentioned

An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:

Web usability Persuasion Web accessibility None of the mentioned

A method of modelling and describing user tasks for an interactive application is referred to as:

Customer journey Primary persona Use case Web design persona

Information architecture influences:

Answer choice Site structure Labeling Navigation design

Also known as schematics, a way of illustrating the layout of an individual webpage is a:

Wireframe Sitemap Card sorting Blueprint

A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:

Wireframe Blueprint Sitemap Card sorting

A relation is in this form if it is in BCNF and has no multivalued dependencies:

Second normal form.

Third normal form.

Fourth normal form.

Domain/key normal form.

The different classes of relations created by the technique for preventing modification anomalies are called:

Normal forms.

Referential integrity constraints.

Functional dependencies.

None of the above is correct.

Row is synonymous with the term:

Record.

Relation.

Column.

Field.

The primary key is selected from the:

Composite keys.

Determinants.

Candidate keys.

Foreign keys.

Quiz/Test Summary
Title: Normalization : The process of organizing the data in the database
Questions: 15
Contributed by:
Steve