数据库系统原理

2„7.1(Summarize)„7.2(RequirementAnalysis)„7.3(ConceptionDesign)„7.4(LogicalDesign)„7.5(PhysicalDesign)„7.6(Running&Maintain)37.1„7.1.1„7.1.2„7.1.34MIS„MIS……………„„57.1.1„…“”………677.1.2„NewOrleans¾„E-R¾„3NF¾„ODLObjectDefinitionLanguage¾„…SybasePowerDesigner…OracleDesigner2000…CASE87.1.3DBMSE-RODL9a=0;if(i=j){for(kDB10117.1.4127.2„7.2.1„7.2.2„7.2.3„7.2.413147.2„7.2.1……„„„„15•16171801##1.2.1.2.3.**197.2„7.2.2…1.„…„…20217.2.2()„2.(SA)…zzzzz222324257.2.3„1.…====…==…==……267.2.3()„2.…………………27•28„29/1.02.03.0307.2.4„………DD…DFD31„…„……………32„„33DFDDD347.3„7.3.1„7.3.2„7.3.3ER„7.3.4357.3.2„….….….…36……37………3839E-RE-R407.3.3E-R„…„()„E-R…„„417.3.3E-R„1.E-R„2.E-R„3.E-R„4.427.3.3.1E-R437.3.3.2E-R„1.………44E-R457.3.3.2E-R„2.…„„…Composite„„467.3.3.2E-R„2.…„„…„„477.3.3.2E-R„2.…„„„48E-R497.3.3.2E-R„ER…ismemberof…ispartof…/issubsetof/isa501.Classification……“ismemberof”512.Aggregation……“ispartof”52ƒ533.Generalization……“issubsetof”…54E-R„…ISAISAP21355E-R567.3.3.3E-R„1.VS577.3.3.3E-R()„1.VS587.3.3.3E-R()„1.VS597.3.3.3E-R()„2.„„„„607.3.3.3E-R()„3.VS…„…„…„617.3.3.3E-R()„4.11KEYKEY1m“m”KEYKEYmn“”KEYKEYclnodeptllsnosnameclnodeptlMsnosnamesnosnameMNcnocnamep62E-RE-RE-R63„E-R(P23419)647.3.4„……………65E-RE-RE-RE-RE-R667.3.4„……„……„……E-R…E-R67E-RE-RE-R687.4„7.4.1…E-R„7.4.2…E-R⇒RDMS…RDMS⇒RDMS…„7.4.3E-R„7.4.4697.4.3E-R„1.…→…→SSNOSNAMEDEPT70717.4.3E-R()„1.…→()727.4.3E-R()„1.…→+737.4.3E-R()„2.…1:1„747.4.3E-R()„2.…1:1„757.4.3E-R()„2.…1:n767.4.3E-R()„2.…m:n777.4.3E-R()„3.„„787.4.3E-R()„4.…ABRCCDSSRD()79E-Rn1mmnm1m80(1)„E-R…………81()(2)„„…………„1:11:nn182()(3)„…mnn837.5„7.5.1…DB…DB„7.5.2……847.5„7.5.3…„„I/O„HASH…„„857.6„„„DB„…DBA86„E-RE-R87