1.
Why do we normalize our databases?
Normalizing databases is an important practice in database design aimed at reducing data redundancy and improving data integrity. We normalize data for
data consistency, improving data integrity, simplifying data maintenance, and scalability and flexibility
.
2.
If a table has a primary key made up of a single attribute, and the table is in 1NF, is that table automatically in 2NF? Why?
No, table with a primary key made up of a single attribute and
that is in 1NF is not necessarily automatically in 2NF.
3.
Using the dependency diagram answer the questions
a.
Identify and discuss each of the indicated dependencies
C3-C6 are the functional dependencies, C1(C1
C3), b.
What changes do you need to make to go to 2NF? Make the dependency diagram(s).
C1
C2
C3
C4
C5
C6
c.
What changes do you need to make to go to 3NF? Make the dependency diagram(s).
C1
C2
C3
C4
