SECTION A: BASIC CONCEPT

What is the process of converting an unnormalized relation into a normalized relation

called?

a$.$ Data modeling

b$.$ Database design

c$.$ Normalization

d$.$ Normal form analysis

What is the main purpose of normalization in database design?

a$.$ To reduce data redundancy

b$.$ To improve data integrity

c$.$ To prevent data inconsistency

d$.$ All of the above

Which of the following is an example of a functional dependency?

a$.$ A customer's name and address are dependent on their order history.

b$.$ An employee's salary is dependent on their job title.

c$.$ A product's price is dependent on its availability.

d$.$ All of the above.

describe a relation or table that has not been organized or

structured in any way, which means that it may contain duplicate data and is not suitable

for efficient querying and maintenance.

a$.$ Unnormalized Form $($UNF$)$

b$.$ First Normal Form $(1$NF$)$

c$.$ Second Normal Form $(2NF)$

d$.$ Third Normal Form $(3$NF$)$

In which normal form does a relation eliminate all transitive dependencies?

a$.$ First Normal Form $(1$NF$)$

b$.$ Second Normal Form $(2$NF$)$

c$.$ Third Normal Form $(3$NF$)$

d$.$ Fourth Normal Form $(4$NF$)$