Critical Thinking Questions
Case 11-1
?
One of the employees at PrattLast Associates is attempting to use the normalization process in the design of the database. She has created the following unnormalized table:
?
Account (Product, Audience, CompanyCode, CompanyName, (AccountNum, AccountLast, AccountFirst))
How can she convert this unnormalized table to a table in first normal form?
 a. Remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group. b. Add brackets around the group to not enclosed and keep the parentheses. c. Move the parentheses so that the AccountNum is not included. d. Put parentheses around each key.

What will be an ideal response?

Answer: A