PEAP is a popular extended EAP protocol.

When applying a ________, it is best practice to use muted or pastel colors

A) table style B) theme C) fill color D) built-in cell style

Assume a relation schema, R, that has attributes A, B, C, D, and E. The only functional dependencies (FD’s) are AB ? CDE, D ? E, and CD ? B.

(a) What is a key of R? (b) What does the FD D ? E mean? (c) What does the FD D ? E imply about the redundant storage of information in an instance of R? Explain. (d) The insertion of a new row in R might cause a violation of an FD. In order to prevent this for the FD D ? E we might try one of the following. (e) Is R in 3rd Normal Form? Explain. (f) What is the condition for losslessness? Explain why it is important for a decomposition to be lossless? (g) Give a lossless decomposition of R into two 3rd Normal Form relations R1 and R2. Demonstrate that R1 and R2 are in 3rd Normal Form by showing that the FD’s that apply to each satisfy the conditions for 3rd NF. Show that the decomposition is lossless.