首页 > 编程知识 正文

数据库中的三大范式,数据库第二范式和第三范式区别

时间:2023-05-05 09:40:57 阅读:157391 作者:2761

顶层2NF的例子不合适。

3358 en.Wikipedia.org/wiki/second _ normal _ form

notall2nftablesarefreefromupdateanomalies,however.anexampleofa2nftablewhichsuffersfromupdateanomaliesis 3360

tournamentwinnerstournamentyearwinnerwinnerdateofbirth

dsmoinesmasters 1998 chipmasterson 14 March 1977

Indiana invitational 1998 Alfred rickson 21ju ly 1975

Cleveland open 1999 bob albertson 28 September 1968

des Moines masters 1999 Alfred rickson 21ju ly 1975

Indiana invitational 1999 chipmasterson 14 March 1977

eventhoughwinnerandwinnerdateofbirtharedeterminedbythewholekey { tournament/year } andnotpartofit、 particular Winner/winnerdateofbirthcombinationsareshownredundantlyonmultiplerecords.thisleadstoanupdateanomaly 3360 ifupdatesarenotcarrriedoutcoutcoood

theunderlyingproblemisthetransitivedependencytowhichthewinnerdateofbirthattributeissubject.winnerdateofbirthactuallydepependsosorthacthacttilydesodesondesoreson

thisproblemisaddressedbythirdnormalform (3nf )。

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。