Check the following schema against the different normalizati

Check the following schema against the different normalization rules (i.e., 1NF, 2NF, 3NF, BCNF). Fix the schema if any of the normalization rules is violated. You can make assumptions and write your assumptions.

Pet-details(examDateTime, petNo, petName, petTypeDescription, petTypeID, staffFirstName, staffLastName, examResult, staffNo)

Solution

1NF:

petDetails(examDateTime, petNo, petName, petTypeDescription, petTypeID, staffFirstName, staffLastName, examResult, staffNo)

2NF:

schema1(petNo,petName,petTypeDescription,petTypeID)

schema2(petNo,staffNo,examDateTime,examResult)

3NF:

schema1(petNo,petName,petTypeDescription,petTypeID,examResult)

schema2(examResult,examDateTime)

schema3(examDateTime,staffName,staffNo,)