Homework answers / question archive / PET-SERVICE(PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName,OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge) What are the determinants of this relation or relations?  According to the tables you break up in Question 3, define the tables with primary key(s), foreign key(s), or surrogate keys(s) if necessary

PET-SERVICE(PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName,OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge) What are the determinants of this relation or relations?  According to the tables you break up in Question 3, define the tables with primary key(s), foreign key(s), or surrogate keys(s) if necessary

Statistics

Share With

PET-SERVICE(PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName,OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge)
What are the determinants of this relation or relations? 
According to the tables you break up in Question 3, define the tables with primary key(s), foreign key(s), or surrogate keys(s) if necessary. Are the updated tables 1NF or 2NF or 3NF or BCNF?


Define 1NF. Is PET-SERVICE in 1NF? If not, why not, and what would have to be done to put it into 1NF? Make any changes necessary to put PET-SERVICE into 1NF. If this step requires you to create a additional table, make sure that the new table is also in 1NF.