QUESTION $1$

Questions $17$ will all deal with normalizing a table based on the following information.

$---$

You have been asked to review a database design for a small dog grooming business that has been having problems with data quality. Upon inspecting the database, you see a single table with information about grooming appointments:

Appointments$($DogId$,$ VisitNum, Name, Breed, DateOfBirth, OwnerNumber, GroomerId, GroomerName, GroomerNumber, Service$1,$ Service$2,$ Service$3,$ ApptDate$)$

Discussion with the manager reveals the following functional dependencies:

DogId, VisitNum $$ any other attribute in the table, but perhaps transitively

DogId $$ Name

DogId $$ Breed

DogId $$ DateOfBirth

DogId $$ OwnerNumber

GroomerId $$ GroomerName

GroomerId $$ GroomerNumber

The manager tells you that the service attributes represent places to record services that were used in each appointment. There can be multiple services applied to each appointment, with no set maximum number of services, and some appointments only have one service. Also, it doesn't really matter whether a given service gets recorded in Service$1,$ Service$2,$ or Service$3,$ as they all mean the same thing.

$---$

What is the highest normal form satisfied by the Appointments table as it is depicted above? U$2$a$1$REIsVGRg$4$WYoRXYu$9$mS

This is a multiple$-$choice examination. Please indicate the single best answer to each question. Each question is worth $5$ points. This exam is meant to be challenging, so please check your answers carefully. This is an open$-$everything exam $($books$,$ notes, discussion boards, etc.$)$ the only resource you may not use is another person. You should complete this exam by end$-$of$-$day Eastern time on Saturday.

a$.$

Second Normal Form

b$.$

This table does not meet the criteria of any of the normal forms.

c$.$

First Normal Form

d$.$

Third Normal Form