Question
The following is the relation notation of a table for a veterinary office. VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge) The
The following is the relation notation of a table for a veterinary office.
VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge)
The functional dependencies are given below:
PetID -> PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName
OwnerID -> OwnerLastName, OwnerFirstName
ServiceDescription -> ServiceCharge
PetID, ServiceDate > ServiceDescription, ServiceCharge
Assumption: A pet belongs to only one owner, while an owner may have more than one pet. A pet receives at most one treatment on any given date. Use the functional dependencies above to answer the following three questions. Use relational notation for all relations in your answers. (Note: do not make additional assumptions and functional dependencies) Note: Not using relational notation is subject to 5 points off. Not including dependencies and references are subject to 10 and 5 points off, respectively. Solutions without detailed steps or intermediate steps may be subject to penalties up to 50% off.
2.1. Show the 1NF in relational notation (indicate the primary key).
2.2. Show all partial dependency in the relation only (if any) and identify and show the 2NF. Use relational notation and show the partial dependencies, all relations and their references.
2.3. Show all transitive dependencies (if any) in your answer to question 2.2. Identify and show 3NF (show all relations). Use relational notation. You need to show the transitive dependencies and all relations and their references.
Please show all the work down. Thanks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started