数据库系统基础教程DatabaseSystems.pptx

DepartmentofcomputersciencetechnologyNJUSTDatabaseSystems

数据库系统

DatabaseSystems2.5学分上课、0.5学分上机，共3学分。学习目的：掌握数据库系统的基本概念、原理和方法；学会有效地使用数据库管理系统，完成数据库的设计和对数据库的编程。学习方法：理论结合实践。考核方式及要求：作业（20％）：按时认真完成作业。实验（10％）：完成上机实验并提交实验报告。闭卷考试（70％）：英文试卷。

No.3JeffreyD.Ullman,JenniferWidom.数据库系统基础教程(原书第3版).岳丽华等译.机械工业出版社.2009.AbrahamSilberschatz,HenryF.Korth,S.Sudarshan.DatabaseSystemConcepts(FourthEdition).机械工业出版社./~ullman/fcdb.htmlNo.2No.1ReferencebooksDatabaseSystems

AFirstCourseinDatabaseSystemsTheWorldsofDatabaseSystemTheRelationalModelofData*DesignTheoryforRelationalDatabasesHigh-LevelDatabaseModelsAlgebraicandLogicalQueryLanguage*TheDatabaseLanguageSQLConstraintsandTriggersViewsandIndexesSQLinaServerEnvironmentAdvancedtopicsinRelationalDatabases

No.1TheWorldsofDatabaseSystemsNo.2TheEvolutionofDatabaseSystemsOverviewofaDBMSOutlineofDatabase-SystemStudies

1.1TheEvolutionofDatabaseSystemsWhat’sadatabase?Inessence,adatabaseisacollectionofinformationthatexistsoveralongperiodoftime,oftenmanyyears.Incommonparlance(说法),adatabaseisacollectionofdatathatismanagedbyadatabasemanagementsystem(DBMS).

1.1TheEvolutionofDatabaseSystemsDatabaseApplications:Banking:alltransactions(交易)Airlines:reservations(预定),schedules(航班表)Universities:registration,gradesSales:customers,products,ordersManufacturing:production,inventory(库存),orders,supplychainHumanresources:employeerecords,salaries,taxdeductionsDatabasestouchallaspectsofourlives.

1.1TheEvolutionofDatabaseSystemsADBMSisexpectedto:DataDefinitionLanguage(DDL):createdatabasesandspecifytheirschema(模式).AschemaisagroupofcollectionsofsentencesthatareexpressedbyDDLtodescribethelogicalstructureofthedatabasecompletely.DataQueryLanguageandDataManipulationLanguage:query（查询）andmodify（更新）thedatabasedontheschemaofthedatabase.Supportthest