2.1) (2 Points) Define Partial Dependency. Give a good Example.

2.2) (2 Points) Define Transitive Dependency. Give a good Example.

2.3) (4 Points) Consider a relation T with six attributes ABCDEF where AB is a composite primary key for T. Assume T has the following functional dependencies:

AB -> CDEF

A -> CEF

F -> E

In what normal form is relation T? Explain why?

Is it possible to decompose T into a number of relations in order to achieve a higher normal form? Explain how and show tables.