For each problem below, please answer the following questions:

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

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

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.)

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.).

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)

Problem 2

PetID	OwnerID	Type	Phone	Color	TotalRevenue
P01	O11	Dog	112-112-2233	Brown	800
P05	O02	Dog	132-666-7788	White	250
P12	O11	Cat	112-112-2233	Grey	800
P08	O05	Dog	356-998-0011	Black	660
P06	O02	Cat	132-666-7788	Brown	250

Relation2 (PetID, OwnerID, Type, Phone, Color, TotalRevenue)

FD: OwnerID = OwnerID, Phone, TotalRevenue