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 3

PetID	ServiceID	NumberOfServices	TotalFee	Clinician	Type
P03	FurCleaning	10	1000	Jesse	Cat
P06	FurCleaning	5	600	Jesse	Dog
P03	DentalCleaning	2	300	Alex	Cat
P05	DentalCleaning	6	1200	Alex	Cat
P06	Vaccination	3	150	Mary	Dog

Relation3 (PetID, ServiceID, NumberOfServices, TotalFee, Clinician, Type)

FD1: PetID = Type

FD2: PetID, ServiceID = NumberOfServices, TotalFee, Type

FD3: ServiceID = Clinician