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)) 1. What will be the primary key of the table in first normal form?

2. How can she convert this unnormalized table to a table in first normal form?

An employee at PrattLast Associates is using the normalization process to analyze her database design. She has created the following Account table: Account (Product, Audience, CompanyCode, CompanyName)

3. This table is not in 3NF. Why?

4.How can she convert this table to a table in 3NF? For each determinant that is not a candidate key, remove from the table the fields that depend on this determinant, but do not remove the determinant. Next, create a new table containing all the fields from the original table that depend on this determinant.