Functional Dependency Analysis – Dog Registry
Scenario
You are analyzing a DOG_REGISTRY database table that tracks individual dogs, their breeds, characteristics, owners, and vets. The sample data is shown below.
Your task: For each potential functional dependency (FD) listed, choose whether it is Valid, Invalid, or Partially Valid based on the sample data. Use the Hint button if you need a nudge. Click Check Answer on each FD to get feedback, or Check All at once.
Validity Key
Valid The FD holds for every row — no counterexamples.
Invalid At least one clear counterexample exists in the data.
Partially Valid Appears to hold in some cases but breaks down in others.
Sample Data Table: DOG_REGISTRY (click to expand)
| DogID | DogName | Breed | Color | Size | OwnerID | OwnerName | OwnerCity | VetID | VetName | VetClinic | LastVisitYear | AdoptionFee |
|---|
Results Summary
Full Answer Key
| # | Potential Dependency | Validity | Reason |
|---|