27,579
社区成员
发帖
与我相关
我的任务
分享第三范式的问题,大家帮帮我?!
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
请问这个第三范式表是通过哪几个表怎么得来的?
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
请问这个第三范式表是通过哪几个表怎么得来的?
...全文
请发表友善的回复…
发表回复
目前关系数据库有六种范式：第一范式（1NF）、第二范式（2NF）、第三范式（3NF）、巴斯-科德范式（BCNF）、第四范式(4NF）和第五范式（5NF，又称完美范式）。 本门课程，结合讲师的原创...
