Explain Second Normal Form and provide examples. What will be ...

[j.rubin]

Explain Second Normal Form and provide examples.
 
  What will be an ideal response?

Question 2

The most rapidly growing type of computing is desktop computing.
 
  Indicate whether the statement is true or false

[bfulkerson77]

Answer to Question 1

Second Normal Form removes functional dependencies from entities. A functional dependency is where several attributes form a subgroup or sub theme in the entity. These subgroups should be removed to a separate entity. An example might be Employee table that also contains department information. The Department information would form a sub theme that should be separated into its own entity.

Answer to Question 2

FALSE