Homework 5

Consider the following table

HEALTH HISTORY REPORT

PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE
246 ROVER DOG 12 SAM COOK JAN 13/2002
MAR 27/2002
APR 02/2002
01 - RABIES VACCINATION
10 - EXAMINE and TREAT WOUND
05 - HEART WORM TEST
298 SPOT DOG 2 TERRY KIM JAN 21/2002
MAR 10/2002
08 - TETANUS VACCINATION
05 - HEART WORM TEST
341 MORRIS CAT 4 SAM COOK JAN 23/2001
JAN 13/2002
01 - RABIES VACCINATION
01 - RABIES VACCINATION
519 TWEEDY BIRD 2 TERRY KIM APR 30/2002
APR 30/2002
20 - ANNUALCHECK UP
12 - EYE WASH

1. Find all the non-trivial dependancies.

2. Give the UNF tables:

3. Give the 1NF tables:

4. Give the 2NF tables:

5. Give the 3NF tables:

Solution

Topic revision: r1 - 2013-10-27 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback