(Solved): Exercises What is normalization? What is the purpose of normalization? Describe how normalization su ...

Exercises What is normalization? What is the purpose of normalization? Describe how normalization support database design. What is a repeating group? When is a table in

? Describe the concept of functional dependency. When is a table in 3NF? What is a partial dependency? With what normal for is it associated? Explain the concept of transitive dependency. Given the dependency diagram shown in below, answer items (i)-(iii). (i) Identify and discuss each of the indicated dependencies. (ii) Create a database whose tables are at least in

, showing the dependency diagrams for each table. (iii) Create a database whose tables are at least in

, showing the dependency diagrams for each table.