MySQL

$1.$ Explain the concept of denormalization and in what scenarios it might be

considered useful.

$2.$ Define Second Normal Form $(2$NF$)$ and describe a scenario where a table

is in $2$NF but not in $3$NF$.$

$3.$ Discuss the significance of transitive dependencies in relation to Third

Normal Form $(3$NF$).$

$4.$ Complete the sentences with appropriate database concepts:

$($a$)$ is the process of removing redundancy to increase data integrity.

$($b$)$ A key is a key that uniquely identifies a row in a table.

$($c$)$ integrity refers to ensuring data in a database remains accurate and consistent.

$($d$)$ A table is in Normal Form if it is in $2$NF and all non$-$key

attributes are not transitively dependent on the primary key.

$5.$ What are repeating groups, and why are they problematic in a relational

database?