For each problem below, please answer the following questions:

1. Is this relation in 0NF, 1NF, 2NF, 3NF, or 4NF? (2 points)

2. Please explain why it satisfies or does not satisfy each normal form (2 points)

a. If it is in a certain normal form, please state the requirements of the normal form that the table has satisfied (e.g., You may say This table is in 1NF because all the columns are atomic.)

b. If a normal form is violated, please specify the column(s) that violate the requirement(s) (e.g., You may say This table is not in 1NF because [ColumnName] is not atomic.).

3. Please give two detailed examples of the possible problems associated with this relation if there are any. If there are no problems, please state there are no problems with this relation. (2 points)

The first row in the following tables includes the attribute names. The rest of each table contains example instances.

Problem 1

CharacterID	Mission	Skill
BlackPanther	Patrol	Technology
BlackPanther	Protection	Technology
BlackPanther	Patrol	Leadership
BlackPanther	Protection	Leadership
Romanoff	Training	Immunity
Romanoff	Rescue	Immunity
Romanoff	Training	Agility
Romanoff	Rescue	Agility

Relation1 (CharacterID, Mission, Skill)