Please show tables with pictures of 1nf , 2nf, and 3nd . 2. What are the 1st, 2n
ID: 3890727 • Letter: P
Question
Please show tables with pictures of 1nf , 2nf, and 3nd .
2. What are the 1st, 2nd and 3rd NF? Pst.id | Bet Nam1 REL.lyes | Pet. Age | owner | Visit Date Procedure 01 - RABIES VACCINATION 10 EXAMINE and TREAT JAN 13/2002 MAR 27/2002 APR 02/2002 JAN 21/2002 MAR 10/2002 JAN 23/2001 JAN 13/2002 APR 30/2002 APR 30/2002 1 Brown DOG 12 Sam WOUND 05 HEART WORM TEST Tucker DOG John 08 TETANUS VACCINATION 05 HEART WORM TEST Maggie CAT 4 Sam 01 RABIES VACCINATION 01 RABIES VACCINATION 4 John 20 ANNUAL CHECK UP WeetX BIRD 12 - EYE WASHExplanation / Answer
1NF:
The above table is in 1NF, because:
2NF:
For a table to be in 2NF, it has to satisfy the below two criteria:
In our case, the candidate key was pet_id, visit_date. But pet_id individually can determine pet_name, pet_type, pet_age, owner. So we need to partition the table as below, to convert it to 2NF.
3NF:
For a table to be in 3NF, the following criteria should be met:
The way to find transitive dependencies is to check if any non-prime attribute in our table is able to derive something else in the table. In our tables, there is no such non-prime attribute, which can determine any other attribute. Hence our tables are already in 3NF.
pet_id pet_name pet_type pet_age owner visit_date procedure 1 brown dog 12 sam jan-13-2002 01-Rabies Vaccination 1 brown dog 12 sam mar-27-2002 10-Examine and Treat wounds 1 brown dog 12 sam apr-02-2002 05-Heart Worm Test 2 Tucker dog 2 John jan-21-2002 08-Tetanus Vaccination 2 Tucker dog 2 John mar-10-2002 05-Heart Worm Test