第二章 企业管理的信息化平台(简化本)

11112221CPU1“”(Bit)23CPU()(MHZ)4(byte)5CPUCPU67818bit1KB21010241MB210KB1024KB233360ARPASNAIBMDNADECTRANSPAC……DATAPACNPDNISOOSIISO&CCITT7080OSIINTERNET70801804441…2335551.LANLocalAreaNetwork(1)(2)(3)(4)2.WANWideAreaNetwork(1)(2)(3)(4)3.MANMetropolitanAreaNetwork666(a)(b)(d)(c)(e)47771(1)(2)(3)(4)2(1)(2)8883/45999510101012(hub)(Transiver)(NetworkAdapter)(Modem)(Bridge)(Router)(Gateway)61111111212122TCPIPTCPIPTransmissionControlProtocol/InternetProtocolAPPAInternet7131313TCPIPX.25ORACLEINGRES141414TCPTCPIPOSIIPIP81515155.3Internet5.3InternetInternetInternetTCP/IPInternetARPANETARPANETMILNETInternet(1982)NSFNET(8586ARPANET)Internet161616Internet1InternetInternetInternet“Internet(ISOC)”Internet(NOC)(NIC)9171717Internet1987X.251988E—mail1994InternetInternet(NCFC)(CHINANET)(CERNET)(CHINAGBNET)(UNINET)1997(CNNIC)181818Internet1.(E--mail)2.(FTP)3.WWW(WWW)4.(USENETBBS)5.(TELNET)6.(ARCHIE)7.(GOPHER)8.(WAIS)10191919Internet1IPInternetIPIP324W.X.Y.Z0—255210.43.192.1IP()IP=+=NETid+HOSTidIP5(A__E),ABC202020240---255E224---239D192---223C128---191B1---127(126)A112121212Internet()www.cscu.edu.cn3URLInternetWWWURL()URL:///222222zzIntranetIntranetTCP/IPTCP/IPWWWWWWInternetInternetzz{{{{//(Client/Server)(Client/Server){{//(Browse/Server)(Browse/Server)12232323zzIntranetIntranet{{{{((EE--Mail,Newsgroups,ChatMail,Newsgroups,Chat,,Videoconferencing)Videoconferencing){{(()){{((242424zzIntranetIntranet{{((EDIEDI)){{{{zzIntranetIntranet(P69)(P69){{WWWWWW{{{{InternetInternet{{13252525zzIntranetIntranet(P70)(P70){{{{{{{{zz{{p71p71262626331.1.zz20205050zzzza)a)b)b)c)c)d)d)1427272711112222nnnn......2828282.2.zz202050506060zzzza)a)b)b)c)c)d)d)e)e)15292929111222nnn111222mmm......3030303.3.zz20206060zzzza)a)b)b)c)c)d)d)e)e)16313131zz{{::{{::{{::DataBaseDataBaseManagementsystemManagementsystem323232zzzz::DataBaseDataBaseManagementsystemManagementsystem::{{DDL/DDL/DataDefinedDataDefinedLanguageLanguage{{DataManipulationLanguageDataManipulationLanguage{{::17333333zz{{DBASDBASzz{{{{{{{{{{343434zz()()18353535AABB11DDEE33CC22//363636zzzzDDL(DDL(DataDefinitionLanguage)DataDefinitionLanguage)zz19373737zzzzzzzzDDLDDL383838zzDDLDDL™™20393939DBMSDBMSzzzzDBMSDBMSzzzzDBADBADatabaseDatabaseAdministratorAdministrator404040DBMSDBMSOSDBMS214141411.1.DBMSDBMSDMLDMLDBMSDBMSDMLDML2.2.DBMSDBMS3.3.DBMSDBMS4.4.DBMSDBMSOSOS5.5.OSOSDBMSDBMS6.6.DBMSDBMS424242//OSOSDBMSDBMS22434343(DataModel)(DataModel)zzzzzz(Domain)(Domain)zzzz(Key)(Key)zz444444zz{{{{(enterprise)(enterprise)zz::{{{{zz(object)(object)Example:Example:zz(())Example:Example:zz::(labeledbox)(labeledbox)23454545customerloancustomer-idcustomer-customer-customer-loan-amountnamestreetcitynumber464646zz(setofattributes)(setofattributes),,customer=(customer-name,social-security,customer-street,customer-city)account=(account-number,balance)zz(Domain)(Domain)——zzzz(Attributetypes)(Attributetypes){(simple)(composite){(single-value)(multi-value)zdependent-name{NULLz(){(Derived)zzStart-date()employment-length24474747customer-namecustomer-address:(labeledoval)(arc)484848zz(1:1)(1:1)zz(1:n)(1:n)zz(m:n)(m:n)25494949zz(relationship)(relationship)(association)(association)HayesdepositorA-102customeraccountzzn(nn(n≥≥2)2)nnRR{Example:(Hayes,A-102)∈depositor{:zz::(labeleddiamond)(labeleddiamond){(arc){(arrowheads)cardinalityconstraints),...,,(},...,,|),...,,{(21221121nnnneeeEeEeEeeee∈∈∈)(cross)Cartesian(...set)(empty21nEEE×××φnEEE,...,,21505050zz{customeraccountdepositoraccess-date{customerdepositor0account{accountdepositor0customer26515151zz(binary)(2){Binary(n=2)()ismostimportantcasebyfarz2525252zcustomerborrowerloanzloanborrowercustomer27535353zzloanloanborrowerborrowercustomercustomerzzcustomercustomerborrowerborrower((00)loan)loan545454zzloanloanborrowerborrower((00)customer)customerzzcustomercustomerborrowerborrowerloanloan28555555zcustomerborrower(0)loanzloanborrower(0)customer565656zzEE--RREntityEntity--RelationshipRelationship19761976P.P.S.ChenP.P.S.ChenzzEE--RR1.1.2.2.3.3.4.4.29575757zz{{zz(onetoone)(onetoone){{zz(onetomany)(onetomany)(manytoone)(manytoone){{“many”“one”zz(manytomany)(manytomany){{585858EE--RRAABBAABBAABB(A)1:1(B)1:n(C)m:n111nmn30595959EE--RRAABBCCAABBCC1mnmnp606060EE--RRAABBCCDD3161616162626232636363zz{{zz((SuperkeySuperkey)){{zz(Candidatekey)(Candidatekey){{zz(Primarykey)(Primarykey){646464zzOOOOzz(Specialization)(Specialization){(Top-down){(subgroupings){(subgroupings){{ISAzz(Generalization)(Generalization){—{zz{{33656565(cont.)(cont.)666666z1.1.2.2.3.3.994.4.{{{{34676767zz20206060--8080zzzzIBMIBMIMS(InformationIMS(InformationManagementSystem)ManagementSystem)zz1.1.2.2.3.3.686868R1R1R2R2R3R3R4R4R5R5R6R6R1R2R3R1R2R4R5R635696969zDBTGDBTGzz(1)(1)(2)(2)(3)(3)707070R1R1R2R2R5R5R3R3R4R4367171711.1.2.2.727272zzzzzzzzzzzz00011011982.05.01………………………………37737373zzR(AR(A11:D:D11,A2:D2,,A2:D2,AAnn:D:Dnn))RRAA11AAnnDD11DnDnzz1.1.2.2.3.3.NormalNormalFormForm747474Delphi0001101807582901982.05.01……………………………………………………38757575TheEndThankyou