1BeijingUniversityofPostsandTelecommunications(BUPT)SchoolofComputerScienceandTechnologySyllabusforDatabaseSystemPrinciples1.OverviewsCourseNo.:323?04105CourseTitle:DatabaseSystemPrinciplesCourseCredit:3Credits,requiredcourseSemesterandYear:Spring2007Class:04411—04415Teachinghours:Classteaching:51hoursAfter-classexperiments:17hoursCoursedesign,orprofessionalpracticeforthiscourse:（数据库系统综合课程设计）,30hours,1credits,conductedinthe3rdsemester.Prerequisites:DataStructuresDiscreteMathematicsOperatingSystems2AlgorithmsDesignandAnalysis2.LectureMeetingsTime:TusedayAM:8:00–10:00FridayAM:8:00–10:00,onlyoddweeksLocation:Room539,3thTeachingBuilding3.FacultyInstructorName:Dr.WenYE(叶文)Office:Room918,3rdTeachingBuildingOfficeHours:Wednesday3:00to4:30PM,Iamalsoavailablebyappointmentatatimemoreconvenientforyou,especiallyattheendofthissemesterPhone:86-10-62282633(O)E-mail:gryew@263.net,yewen@bupt.edu.cnExperimentsDirectors:Name:???Responsibility:directingexperimentsOffice:Room913,MainBuilding3OfficeHours:Friday14:00to17:00PM,orbyappointmentGraduateTeachingAssistant:Name:??()Responsibility:checkinghomeworkOffice:Room918,3rdTeachingBuildingOfficeHours:Wednesday13:30to15:00PM,orbyappointmentE-mail:4.TextBook1.AbrahamSilberschatz,HenryF.Korth,S.Sudarshan,DatabaseSystemConcepts(ForthEdition,FifthEdition),HigherEducationPressandMcGraw-HillCompanies,Beijing,May,2002.References1.中国计算机科学与技术学科教程2002研究组，中国计算机科学与技术学科教程2002，清华大学出版社，北京，2002年8月。2.周立柱冯建华等编著，SQLServer数据库原理设计与实现，清华大学出版社，北京，2004年3月。3.李建中，王珊，《数据库系统原理》，电子工业出版社，北京，1998年8月。4.萨师煊，王珊，《数据库系统概论》（第3版），高等教育出版社，2000年2月。5.ThomasM.Connolly,CarolynE.Begg,DatabaseSolutions:AStepbyStepGuidetoBuildingDatabases,ChinaMachinePressandPrenticeHall,Beijing,Feb.2004。6.郑阿奇，刘启芬，顾韵华，SQLServer实用教程，电子工业出版社，北京，2002年8月。45.WebsitesCourseLecturenotesandothercoursematerialsmaybepostedonthefollowingwebsiteonaregularbasis.URL:http://202.112.102.19/part2/i.asp?id=4.aspStudentsareexpectedtocheckitregularly，studentscanalsogetlecturenotesthroughemails.Others1.http://www.computer.org/education/cc2001/steelman/cc2001/6.CourseObjectsandOutcomesDatabaseSystem(DBS)isanessentialpartofInformationManagementknowledgeareaspecifiedinChinaComputingCurricula2002andComputingCurricula2001byACMandIEEE/CS.DatabaseSystemPrinciplesisarequiredcourseforjuniorsmajoringincomputer.Thiscourseisaimedtohelpover400juniorsmajoringincomputerscienceandtechnologytoacquirefullmasteryofdatabaseprinciplesandmethodologiesbyemployingMicrosoftSQLServertechnologiesandproductsinin-classteaching,after-classexperimentsandprofessionalpracticeintheshortterm.5Thein-classteachingisdesignedtobeanintroductiontotheconcepts,principles,componentsandmethodologiesofDatabasesystems.ThiscoursewillalsobeamixtureofboththeoryandpracticalstudywherewewillcomplementtheorywithSQLServer-basedexperimentsandprofessionalpractices.MicrosoftSQLServer2000isselectedasacasestudyforthecourseDatabaseSystemPrinciplesinBUPT.Inparallelwithin-classlearning,thestudentsarerequiredtofinishseveralexperimentsonDBS，whichwillhelpthemacquiringcompletemasteryoftheknowledgetaughtinclassandbecomeskilledatoperatingpracticalDBMSlikeSQLServer.Duringtheshortterm(usuallytwoattheen...
