比较偏的问题,谁帮帮我?
Question 1
Identify any repeating groups and functional dependencies in the PATIENT relation. Show all the intermediate steps to derive the Third Normal Form
-----------------------------------------------------------------
Patient ID Name Group ID GroupName Appdate Consultant District Sample
00001 Mary A Apple 1/6/2004 Mak West Urine
00001 Mary A Apple 6/12/2004 KK Central None
00001 Mary A Apple 3/5/2005 Mak West Blood
00002 John B Orange 4/5/2004 Mak West None
00002 John B Orange 2/1/2005 PY East None
00003 Peter C Pineapple 3/11/2004 PY East Blood
00003 Jack D Strawberry 9/9/2004 PY East Urine
00004 Ester E pear 11/10/2005 KK Central none
请问这个第三范式表是通过哪几个表怎么得来的?