管理信息系统(mis)6new

《管理信息系统(mis)6new》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Lecture05:ImplementingaDatabasewithMicrosoftAccessSOLOMONDATABASEThestepstocreatingadatabaseare1.Defineentityclassesandprimarykeys2.Definerelationshipsamongtheentityclasses3.Definefieldsforeachrelation(file)4.Useadatadefinitionlanguagetocreatethedatabase,whichisthefocusofthisModule10/28/2011Schoo

2、lofBusinessandAdministration,NortheasternUniversity,Shenyang2ModJ-2SOLOMONDATABASEInFigureJ.1(p.478)onthefollowing3slides,we’verecreatedthecorrectdatabasestructurefromExtendedLearningModuleCRevisitModuleCifyouneedarefresher10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenya

3、ng3ModJ-3SOLOMONDATABASE10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenyang4ModJ-4SOLOMONDATABASE10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenyang5ModJ-5SOLOMONDATABASE10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenyang6ModJ

4、-6CreatingSolomon’sDatabaseDatadictionary-containsthelogicalstructurefortheinformationTocreatetheSolomonEnterprisedatabase:1.StartMicrosoftAccess2.ClickonBlankDatabaseintheupperleftcornerofthescreen3.EnterSolomonEnterprises.mdbasthedatabasename4.ClickonCreate10/28/2011SchoolofBusinessandAdminist

5、ration,NortheasternUniversity,Shenyang7ModJ-7CreatingSolomon’sDatabaseEnteradatabasenameandclickonCreateClickonBlankDatabase10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenyang8ModJ-8CreatingSolomon’sDatabaseOurrecommendation:Createarelation(table)inDesignview:Mustswitchfr

6、omDatasheetViewtoDesignViewClickonViewintheupperleftcornerandthenDesignViewEnteratablenameUsetheDesignViewtoenterthespecificationsforthetable10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenyang9ModJ-9CreatingSolomon’sDatabaseThisisDesignView–ourrecommendationforcreatingth

7、etablesinadatabaseToswitchtoDesignView,clickonViewandthenDesignView10/28/2011SchoolofBusinessandAdministration,NortheasternUniversity,Shenyang10ModJ-10CreatingtheRawMaterialRelationEnterthefourfieldsoftheRawMate