东北大学：某学院计算机科学与技术专业《数据库原理》课程教学大纲

数据库原理教学大纲Principles of Database Subject Syllabus一，课程信息SubjectInformation课程编号：开课学期：43100213006Subject IDSemester课程分类：所属课群：专业教育PA专业基础MFCategorySection课程学分：总学时/周：348/4Credit PointsTotal Hours/Weeks理论学时：实验学时：408LECT. HoursEXP. HoursPBL学时:实践学时/周：00PBL HoursPRAC. Hours/Weeks东北大学悉尼智能科技学院开课学院：Sydney Smart适用专业：计算机科学与技术CSTCollegeTechnology CollegeStreamNortheasternUniversity课程属性：课程模式：必修Compulsory互认EQVPatternMode敬茂华中方课程协调人：成绩记载方式：百分制MarksNEU CoordinatorResult TypeJingMaohua先修课程：离散数学DiscreteMathematicsRequisitesSilberschatzBA,KorthHF,SudarshanS.Database System英文参考教材：Concepts(7thEdition).McGraw-HillENTextbooks王珊，萨师煊（2014）数据库系统概论（第5版）中文参考教材Wang Shan, Sa Shixuan.(2014).Database System Concepts (5thCN TextbooksEdition).Higher Education.教学资源：https://www.microsoft.com/zh-cn/sql-server/sql-server-2019Resources课程负责人(撰写人)敬茂华提交日期：单击或点击此处输入日期。Subject DirectorJingMaohuaSubmitted Date任课教师(含负责人)：敬茂华，李佳音教戎Jing Maohua,LiJiayinTaught by审核人：批准人：韩鹏史闻博Checked byApproved by批准日期：单击或点击此处输入日期。Approved Date1/16

1 / 16 数据库原理 教学大纲 Principles of Database Subject Syllabus 一、课程信息 Subject Information 课程编号: Subject ID 3100213006 开课学期: Semester 4 课程分类: Category 专业教育 PA 所属课群: Section 专业基础 MF 课程学分: Credit Points 3 总学时/周: Total Hours/Weeks 48/4 理论学时: LECT. Hours 40 实验学时: EXP. Hours 8 PBL 学时: PBL Hours 0 实践学时/周: PRAC. Hours/Weeks 0 开课学院: College 东北大学 悉尼智能科技学院 Sydney Smart Technology College Northeastern University 适用专业: Stream 计算机科学与技术 CST 课程属性: Pattern 必修 Compulsory 课程模式: Mode 互认 EQV 中方课程协调人: NEU Coordinator 敬茂华 JingMaohua 成绩记载方式: Result Type 百分制 Marks 先修课程: Requisites 离散数学 Discrete Mathematics 英文参考教材: EN Textbooks Silberschatz B A ,Korth H F , Sudarshan S . Database System Concepts (7th Edition). McGraw-Hill. 中文参考教材: CN Textbooks 王珊,萨师煊.（2014）数据库系统概论（第 5 版）. Wang Shan, Sa Shixuan. (2014). Database System Concepts (5th Edition).Higher Education. 教学资源: Resources https://www.microsoft.com/zh-cn/sql-server/sql-server-2019 课程负责人(撰写人): Subject Director 敬茂华 JingMaohua 提交日期: Submitted Date 单击或点击此处输 入日期。 任课教师(含负责人): Taught by 敬茂华, 李佳音 Jing Maohua， Li Jiayin 审核人: Checked by 韩鹏 批准人: Approved by 史闻博 批准日期: Approved Date 单击或点击此处输 入日期

二、教学目标SubjectLearningObjectives(SLOs)注：毕业要求及指标点可参照悉尼学院本科生培养方案，可根据实际情况增减行数Note: GA and index can be referred from undergraduate program in SSTC website.Please add/reduce lines based on subject本课程向学生介绍数据库系统的基本概念。学生们将学习如何在实际的应用系统中有效地构建、存储、组织和管理数据，以方便用户的应用。同时还学习如何使用SQL语言进行有效的数据检索和更改，针对具体的应用需求进行需求分析，数据库概念结构设计和逻辑结构设计。本课程教导学生认识到良好的数据库设计和管理的重要性和挑战，这是功能性软件应用程序开发的基础。This subject introduces students to the fundamentals of effective整体目标：database systems. Students are taught how data is structured andOverallObjectivemanaged in an organization in a way that can be used effectively byapplications and users. They also learn to use the language SQL foreffective data retrieval and modification, according to the specificapplication requirements, learn how to study the requirement analysisimplementingdatabase conceptual structuredesignand logical structuredesign.This subject teaches students to appreciate the significance andchallenges of good database design and management, which underpinthedevelopmentof functional software applications培养学生理解与结构化数据的设计和使用相关的主要问题；具有应用数据库设计原则构建概念模型和逻辑数据模型的抽象设计能力：评估数据穴余级别及其对数据库完整性和可维护性的影响。1-1Explain the main issues related to the design and use ofstructured data, Construct conceptual and logical data modelsapplying database design principles; Evaluate data redundancylevels and their impact on database integrity andmaintainability,应用数据建模原理构建概念数据模型：遵循数据规范化原则构建逻辑数据模型：区分好的和坏的数据库设计。Construct conceptual data models applying data modelling1-2（1）专业目标：principles;Construct logical data models adhering to dataProfessional Abilitynormalisation principles;Distinguish between good and baddatabasedesign;学习关系数据库标准语言SQL：熟练掌握数据定义、数据查询、数据操纵和数据控制语句以及完整性约束，具备构造高效的SQL查询以根据需要检索和操作数据的能力；了解查询优化：学习嵌入式SQL和数据库编程。Learn the standard language of relational database SQL;Master1-3data definition, data query, data manipulation, data controlstatements and integrity constraints, and have the ability toconstructefficient SQLqueries toretrieve and manipulate dataasrequired; Understandingqueryplanning&optimization;learnembedded SQL anddatabase programming2/16

2 / 16 二、教学目标 Subject Learning Objectives (SLOs) 注：毕业要求及指标点可参照悉尼学院本科生培养方案，可根据实际情况增减行数 Note: GA and index can be referred from undergraduate program in SSTC website. Please add/reduce lines based on subject. 整体目标: Overall Objective 本课程向学生介绍数据库系统的基本概念。学生们将学习如何在实 际的应用系统中有效地构建、存储、组织和管理数据，以方便用户 的应用。同时还学习如何使用 SQL 语言进行有效的数据检索和更 改，针对具体的应用需求进行需求分析，数据库概念结构设计和逻 辑结构设计。本课程教导学生认识到良好的数据库设计和管理的重 要性和挑战，这是功能性软件应用程序开发的基础。 This subject introduces students to the fundamentals of effective database systems. Students are taught how data is structured and managed in an organization in a way that can be used effectively by applications and users. They also learn to use the language SQL for effective data retrieval and modification, according to the specific application requirements, learn how to study the requirement analysis, implementing database conceptual structure design and logical structure design. This subject teaches students to appreciate the significance and challenges of good database design and management, which underpin the development of functional software applications. （1）专业目标: Professional Ability 1-1 培养学生理解与结构化数据的设计和使用相关的主要问题； 具有应用数据库设计原则构建概念模型和逻辑数据模型的 抽象设计能力；评估数据冗余级别及其对数据库完整性和可 维护性的影响。 Explain the main issues related to the design and use of structured data; Construct conceptual and logical data models applying database design principles; Evaluate data redundancy levels and their impact on database integrity and maintainability; 1-2 应用数据建模原理构建概念数据模型；遵循数据规范化原则 构建逻辑数据模型；区分好的和坏的数据库设计。 Construct conceptual data models applying data modelling principles;Construct logical data models adhering to data normalisation principles;Distinguish between good and bad database design; 1-3 学习关系数据库标准语言 SQL；熟练掌握数据定义、数据 查询、数据操纵和数据控制语句以及完整性约束，具备构造 高效的 SQL 查询以根据需要检索和操作数据的能力；了解 查询优化；学习嵌入式 SQL 和数据库编程。 Learn the standard language of relational database SQL；Master data definition, data query, data manipulation, data control statements and integrity constraints, and have the ability to construct efficient SQL queries to retrieve and manipulate data as required; Understandingquery planning &optimization;learn embedded SQL and database programming

学习事务的基本概念及ACID特性；理解数据库恢复技术；理解并发控制。1-4anditsACIDLearntransactionprocessingproperties;Understanddatabaserecoverytechnology,Understanding concurrency controltheory理解数据库技术的研究学习对提高自主创新能力，建设创新型国家的重要意义。2-1Understandtheresearchand learningofdatabasetechnologyinimproving the ability of independent innovation and buildingan innovation-oriented country.（2）德育目标：认知提升信息技术人才的创新创业能力、构建产学合作的教Essential Quality育网络提高中国在全球发展核心竞争力。Enhancethe innovation and entrepreneurship ability of IT2-2talentsandconstructtheeducationnetworkofindustry-universitycooperationtoimprovethecorecompetitiveness of China in theglobal development课程教学目标与毕业要求的对应关系MatrixofGA&SLOs毕业要求GA教学目标SLOs指标点GAIndex1、工程知识：能够将数学、指标点1-3：了解本专业涉及相关行业的自然科学、工程基础和专业发展趋势以及相关产业的运营模式，具知识用于解决复杂工程问题。备在本专业相关领域进行关系型数据库Knowledge:Engineering设计的能力。1-1,1-2,1-3,Understanding of the development trendApplyknowledgeof1-4,2-1,2-2mathematics, natural science,and operation mode of related industries.engineering fundamentals andand capable of carrying out engineeringan engineering specializationdesign and technical innovation in relatedto the solution of complexfields of this majorengineeringproblems2、问题分析：能够应用数学、自然科学和工程科学的基本原理、方法和手段，识别、表达、并通过文献研究分析指标点2-1：能够应用数学、自然科学和复杂工程问题，以获得有效工程科学的基本原理、方法和手段，分结论。析、识别、表达本专业相关的复杂工程2.ProblemAnalysis:问题；Identify, formulate, researchCapable of analyzing,identifying and1-2, 1-3, 1-4,2-1literatureandanalyzeformulating the major-related complexcomplexengineeringengineering problems using the basicreaching problemsprinciple of mathematics, natural sciencessubstantiatedconclusionsand engineering sciences;usingfirstprinciplesofmathematics,natural sciencesand engineering sciences.3、设计/开发解决方案：能指标点3-1：能够设计针对本专业相关复1-2,1-3,1-4，2-1，3/16

3 / 16 1-4 学习事务的基本概念及 ACID 特性；理解数据库恢复技术； 理解并发控制。 Learn transaction processing and its ACID properties;Understand database recovery technology; Understanding concurrency controltheory. （2）德育目标: Essential Quality 2-1 理解数据库技术的研究学习对提高自主创新能力﹐建设创 新型国家的重要意义。 Understand the research and learning of database technology in improving the ability of independent innovation and building an innovation-oriented country. 2-2 认知提升信息技术人才的创新创业能力、构建产学合作的教 育网络提高中国在全球发展核心竞争力。 Enhance the innovation and entrepreneurship ability of IT talents and construct the education network of industry-university cooperation to improve the core competitiveness of China in the global development. 课程教学目标与毕业要求的对应关系 Matrix of GA & SLOs 毕业要求 GA 指标点 GA Index 教学目标 SLOs 1、工程知识：能够将数学、 自然科学、工程基础和专业 知识用于解决复杂工程问 题。 Engineering Knowledge: Apply knowledge of mathematics, natural science, engineering fundamentals and an engineering specialization to the solution of complex engineering problems. 指标点 1-3：了解本专业涉及相关行业的 发展趋势以及相关产业的运营模式，具 备在本专业相关领域进行关系型数据库 设计的能力。 Understanding of the development trend and operation mode of related industries, and capable of carrying out engineering design and technical innovation in related fields of this major. 1-1，1-2，1-3， 1-4，2-1，2-2 2、问题分析：能够应用数学、 自然科学和工程科学的基本 原理、方法和手段，识别、 表达、并通过文献研究分析 复杂工程问题，以获得有效 结论。 2. Problem Analysis: Identify, formulate, research literature and analyze complex engineering problems reaching substantiated conclusions using first principles of mathematics, natural sciences and engineering sciences. 指标点 2-1：能够应用数学、自然科学和 工程科学的基本原理、方法和手段，分 析、识别、表达本专业相关的复杂工程 问题； Capable of analyzing, identifying and formulating the major-related complex engineering problems using the basic principle of mathematics, natural sciences and engineering sciences; 1-2，1-3，1-4,2-1 3、设计/开发解决方案：能 指标点 3-1：能够设计针对本专业相关复 1-2,1-3,1-4，2-1

够设计针对复杂工程问题的杂工程问题的解决方案，能够设计和开2-2解决方案，设计满足特定需发实现特定功能、满足特定需求的计算求的系统、单元或流程，并机、软件或网络系统；能够在设计环节中体现创新Capableof designing solutions to complex意识，考虑社会、健康、安engineering problems related to the major,全、法律、文化以及环境等and capable of designing and developing因素。computers, software or network systemsDesign/Developmentofthat can function specifically and meetSolutions: Design solutionsspecific requirementsforcomplexengineering指标点3-2：能够对不同设计方案进行比problems and design systems,较和优化，在工作各环节中具有创新意components orprocessesthatmeet specified needswith识。appropriate consideration forCapable of comparing and optimizingpublic health, and safety,different design schemes, and innovative incultural,societal,andall aspects of the work.environmentalconsiderations指标点5-1：能够对本专业相关复杂工程问题进行建模与分析，理解获取相关信息参数的必要性与基本方法，并理解其局限性；5、使用现代工具：能够针对5-1: Capable of modeling and analyzing复杂工程问题，开发、选择complex engineering problems related to与使用恰当的技术、资源、the major, understanding the necessity and现代工程工具和信息技术工具，包括对复杂工程问题的basicmethodsof obtainingrelevant预测与模拟，并能够理解其parameters,andtheirinformation局限性。Modern Tool Usage: Create,limitations1-3,1-4,2-1select and apply appropriate指标点5-2：熟悉解决本专业相关复杂工sandtechniques,resources程问题所需的技术和资源，能够运用现modern engineering and ITtools, including prediction and代信息技术进行文献检索和资料查询，modeling,tocomplex获取专业解决方案；engineering problems, with anoftheunderstanding5-2:Familiar with the technology andlimitationsresourcesneededtosolvecomplexengineering problems related to this major,and be able to use modern informationtechnology for literature retrieval and dataquery to obtain professional solutions4/16

4 / 16 够设计针对复杂工程问题的 解决方案，设计满足特定需 求的系统、单元或流程，并 能够在设计环节中体现创新 意识，考虑社会、健康、安 全、法律、文化以及环境等 因素。 Design/Development of Solutions: Design solutions for complex engineering problems and design systems, components or processes that meet specified needs with appropriate consideration for public health, and safety, cultural, societal, and environmental considerations. 杂工程问题的解决方案，能够设计和开 发实现特定功能、满足特定需求的计算 机、软件或网络系统； Capable of designing solutions to complex engineering problems related to the major, and capable of designing and developing computers, software or network systems that can function specifically and meet specific requirements. 指标点 3-2：能够对不同设计方案进行比 较和优化，在工作各环节中具有创新意 识。 Capable of comparing and optimizing different design schemes, and innovative in all aspects of the work. 2-2 5、使用现代工具：能够针对 复杂工程问题，开发、选择 与使用恰当的技术、资源、 现代工程工具和信息技术工 具，包括对复杂工程问题的 预测与模拟，并能够理解其 局限性。 Modern Tool Usage: Create, select and apply appropriate techniques, resources and modern engineering and IT tools, including prediction and modeling, to complex engineering problems, with an understanding of the limitations. 指标点 5-1：能够对本专业相关复杂工程 问题进行建模与分析，理解获取相关信 息参数的必要性与基本方法，并理解其 局限性； 5-1: Capable of modeling and analyzing complex engineering problems related to the major, understanding the necessity and basic methods of obtaining relevant information parameters, and their limitations. 指标点 5-2：熟悉解决本专业相关复杂工 程问题所需的技术和资源，能够运用现 代信息技术进行文献检索和资料查询， 获取专业解决方案； 5-2: Familiar with the technology and resources needed to solve complex engineering problems related to this major, and be able to use modern information technology for literature retrieval and data query to obtain professional solutions. 1-3，1-4，2-1

指标点5-3：能够针对本专业相关复杂工程问题，选择与使用恰当的技术、资源、现代工程工具和信息技术工具。5-3:Capable of selecting and usingappropriatetechnology,resources,modernengineeringtoolsandinformationtechnologytoolstosolvecomplexengineering problems related to the major三、教学内容Content(Topics)注：以中英文填写，各部分内容的表格可根据实际知识单元数量进行复制、扩展或缩减Note: Filled in both CN and EN, extend or reduce based on the actual numbers of knowledge unit(1)理论教学Lecture知识单元序号：支撑教学目标：11-1,1-2,1-3,1-4Knowledge Unit No.SLOs Supported知识单元名称绪论Unit TitleIntroduction数据库系统应用：Databasesystemapplications数据库系统的目的:Purposeofdatabasesystems数据：Viewofdata数据库语言：Databaselanguages知识点：数据库设计：DatabasedesignKnowledge Delivery数据库和应用程序体系结构:Databaseandapplicationarchitecture数据库用户和管理员：Databaseusersandadministrators数据库系统的历史History of database systems了解:数据库系统的历史RecognizeHistory of database systems数据库系统应用数据库系统的目的数据库语言理解：History of database systems, Purpose of database学习目标：Understandsystems, Database languagesLearning Objectives数据库设计，数据库和应用程序体系结构，数据库用户掌握：和管理员，MasterDatabase design; Database and application architecture:Database users and administrators德育目标2-1.2-2Moral Objectives重点：数据库设计，数据库和应用程序体系结构，数据库用户和管理员；Key PointsDatabasedesign;Databaseandapplication architecture;Databaseusers5/16

5 / 16 指标点 5-3：能够针对本专业相关复杂工 程问题，选择与使用恰当的技术、资源、 现代工程工具和信息技术工具。 5-3: Capable of selecting and using appropriate technology, resources, modern engineering tools and information technology tools to solve complex engineering problems related to the major. 三、教学内容 Content (Topics) 注：以中英文填写，各部分内容的表格可根据实际知识单元数量进行复制、扩展或缩减 Note: Filled in both CN and EN, extend or reduce based on the actual numbers of knowledge unit (1) 理论教学 Lecture 知识单元序号: Knowledge Unit No. 1 支撑教学目标: SLOs Supported 1-1,1-2,1-3,1-4 知识单元名称 Unit Title 绪论 Introduction 知识点: Knowledge Delivery 数据库系统应用: Database system applications 数据库系统的目的:Purpose of database systems 数据:View of data 数据库语言:Database languages 数据库设计:Database design 数据库和应用程序体系结构:Database and application architecture 数据库用户和管理员:Database users and administrators 数据库系统的历史 History of database systems 学习目标: Learning Objectives 了解: Recognize 数据库系统的历史 History of database systems 理解: Understand 数据库系统应用,数据库系统的目的,数据库语言 History of database systems; Purpose of database systems; Database languages 掌握: Master 数据库设计,数据库和应用程序体系结构,数据库用户 和管理员, Database design; Database and application architecture; Database users and administrators 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 数据库设计,数据库和应用程序体系结构,数据库用户和管理员; Database design; Database and application architecture; Database users

and administrators难点：数据库和应用程序体系结构Focal pointsDatabaseand application architecture知识单元序号支撑教学目标：21-1,1-2Knowledge Unit No.SLOs Supported知识单元名称关系模型简介Unit TitleIntroduction to the relational model关系数据库结构：Structureofrelationaldatabase知识点：数据库模式；Database schema码；KeysKnowledge Delivery关系查询语言：Relationalquerylanguage关系代数Therelationalalgebra了解:关系数据库结构RecognizeStructureof relational database学习目标：理解：数据库模式，关系查询语言UnderstandLearning ObjectivesDatabase schema, relational querylanguage掌握：关系代数MasterThe relational algebra德育目标2-1,2-2Moral Objectives重点：数据库模式；关系代数Key PointsDatabase schema, The relational algebra难点：关系代数Focal pointsTherelational algebra知识单元序号：支撑教学目标：31-1, 1-3,Knowledge Unit No.SLOs Supported知识单元名称SQL语言基础Unit TitleIntroduction to SQLSQL概述：Overviewofthe SQLquery languageSQL数据定义：SQLdatadefinitionSQL查询语句语法结构：BasicstructureofSQLqueries知识点附加基本操作：AdditionalbasicoperationsKnowledge Delivery集合操作：Setoperations空值：Nullvalues聚集函数：Aggregatefunctions嵌套子查询：Nestedsubqueries了解：SQL概述RecognizeOverview of the SQLquerylanguage理解：SQL数据定义UnderstandSQLdata definition学习目标SQL查询语句语法结构：Basic structureof SQLLearning Objectivesqueries掌握：附加基本操作：AdditionalbasicoperationsMaster集合操作：Setoperations空值：Nullvalues6/16

6 / 16 and administrators 难点: Focal points 数据库和应用程序体系结构 Database and application architecture 知识单元序号: Knowledge Unit No. 2 支撑教学目标: SLOs Supported 1-1,1-2 知识单元名称 Unit Title 关系模型简介 Introduction to the relational model 知识点: Knowledge Delivery 关系数据库结构：Structure of relational database 数据库模式；Database schema 码；Keys 关系查询语言；Relational query language 关系代数 The relational algebra 学习目标: Learning Objectives 了解: Recognize 关系数据库结构 Structure of relational database 理解: Understand 数据库模式，关系查询语言 Database schema, relational query language 掌握: Master 关系代数 The relational algebra 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 数据库模式；关系代数 Database schema; The relational algebra 难点: Focal points 关系代数 The relational algebra 知识单元序号: Knowledge Unit No. 3 支撑教学目标: SLOs Supported 1-1，1-3， 知识单元名称 Unit Title SQL 语言基础 Introduction to SQL 知识点: Knowledge Delivery SQL 概述：Overview of the SQL query language SQL 数据定义：SQL data definition SQL 查询语句语法结构：Basic structure of SQL queries 附加基本操作：Additional basic operations 集合操作：Set operations 空值：Nullvalues 聚集函数：Aggregatefunctions 嵌套子查询：Nestedsubqueries 学习目标: Learning Objectives 了解: Recognize SQL 概述 Overview of the SQL query language 理解: Understand SQL 数据定义 SQL data definition 掌握: Master SQL 查询语句语法结构：Basic structure of SQL queries 附加基本操作：Additional basic operations 集合操作：Set operations 空值：Nullvalues

聚集函数：Aggregatefunctions嵌套子查询：Nestedsubqueries德育目标2-1,2-2Moral ObjectivesSQL查询语句语法结构，附加基本操作，集合操作，空值，聚集函重点：数，嵌套子查询Key PointsBasic structure of SQL queries, Additional basic operations; Setoperations;Nullvalues;Aggregatefunctions,Nestedsubqueries难点：嵌套子查询Focal pointsNestedsubqueries知识单元序号：支撑教学目标：41-2, 1-3Knowledge Unit No.SLOs Supported知识单元名称中级及高级SQL语言Unit TitleIntermediateSQLandadvanced SQL联接：Joinexpressions视图：Views完整性约束：Integrityconstraints知识点：SQL数据类型和模式:SQLDataTypesandSchemasKnowledge Delivery定义索引:Indexdefinition in SQL触发器：Triggers函数和过程：Functionsandprocedures了解：触发器,函数和过程RecognizeTriggers; Functions and procedures学习目标：理解：完整性约束，SQL数据类型和模式UnderstandIntegrity constraints; SQL Data Types and SchemasLearning Objectives掌握：联接,视图,定义索引MasterJoinexpressions;Views;IndexdefinitioninSQL德育目标2-1,2-2Moral Objectives重点：联接,视图,定义索引Key PointsJoin expressions; Views; Index definition in SQL难点：触发器，函数和过程Focal pointsTriggers; Functions and procedures知识单元序号：支撑教学目标51-1,1-2SLOs SupportedKnowledge Unit No.知识单元名称数据库设计Unit TitleDatabase design数据库设计过程Database design process知识点：数据字典Knowledge DeliveryData dictionary数据流图Data flow diagram7/16

7 / 16 聚集函数：Aggregatefunctions 嵌套子查询：Nestedsubqueries 德育目标 Moral Objectives 2-1,2-2 重点: Key Points SQL 查询语句语法结构，附加基本操作，集合操作，空值，聚集函 数，嵌套子查询 Basic structure of SQL queries; Additional basic operations; Set operations;Nullvalues; Aggregatefunctions; Nestedsubqueries 难点: Focal points 嵌套子查询 Nestedsubqueries 知识单元序号: Knowledge Unit No. 4 支撑教学目标: SLOs Supported 1-2，1-3 知识单元名称 Unit Title 中级及高级 SQL 语言 Intermediate SQL andadvanced SQL 知识点: Knowledge Delivery 联接:Join expressions 视图:Views 完整性约束:Integrity constraints SQL 数据类型和模式:SQL Data Types and Schemas 定义索引: Index definition in SQL 触发器: Triggers 函数和过程: Functions and procedures 学习目标: Learning Objectives 了解: Recognize 触发器,函数和过程 Triggers; Functions and procedures 理解: Understand 完整性约束, SQL 数据类型和模式 Integrity constraints; SQL Data Types and Schemas 掌握: Master 联接,视图,定义索引 Join expressions; Views; Index definition in SQL 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 联接,视图,定义索引 Join expressions; Views; Index definition in SQL 难点: Focal points 触发器,函数和过程 Triggers; Functions and procedures 知识单元序号: Knowledge Unit No. 5 支撑教学目标: SLOs Supported 1-1,1-2 知识单元名称 Unit Title 数据库设计 Database design 知识点: Knowledge Delivery 数据库设计过程 Database design process 数据字典 Data dictionary 数据流图 Data flow diagram

运用E-R模型进行数据库概念结构设计Databasedesign using the E-R model将E-R模型转换为关系模式ReducingE-Rdiagramstorelationalschemas复杂属性了解：ComplexattributesRecognize扩展的E-R模型Extended E-R features删除实体集中的几余属性学习目标：理解：RemovingRedundantAttributes inEntitySetsUnderstandLearning Objectives运用E-R模型进行数据库概念结构设计掌握：Databasedesign using the E-R modelMaster将E-R模型转换为关系模式Reducing E-R diagramstorelationalschemas德育目标2-1,2-2Moral Objectives运用E-R模型进行数据库概念结构设计重点：Databasedesign using the E-R modelKey Points将E-R模型转换为关系模式ReducingE-Rdiagramstorelationalschemas运用E-R模型进行数据库概念结构设计，将E-R模型转换为关系难点：模式Focal pointstheE-RE-RDatabasedesignusingmodel;Reducingdiagramstorelationalschemas知识单元序号支撑教学目标：61-2, 1-3Knowledge Unit No.SLOs Supported知识单元名称关系数据设计理论Unit TitleRelational database design theory良好关系设计的特点Features of good relational designs函数依赖：Functional-dependency theory使用函数依赖关系进行分解知识点：Decomposition using functional dependenciesKnowledge Delivery范式:Normalforms第一范式到BC范式：1NF,2NF,3NF,BCNF使用函数依赖关系的分解算法：Algorithms fordecomposition using functional dependencies了解：多值依赖，4NE，5NF学习目标：RecognizeMultivalued Dependencies, 4NF, 5NF理解：Learning Objectives良好关系设计的特点UnderstandFeatures ofgood relational designs8/16

8 / 16 运用 E-R 模型进行数据库概念结构设计 Databasedesign using the E-R model 将 E-R 模型转换为关系模式 Reducing E-R diagramstorelationalschemas 学习目标: Learning Objectives 了解: Recognize 复杂属性 Complex attributes 扩展的 E-R 模型 Extended E-R features 理解: Understand 删除实体集中的冗余属性 Removing Redundant Attributes in EntitySets 掌握: Master 运用 E-R 模型进行数据库概念结构设计 Databasedesign using the E-R model 将 E-R 模型转换为关系模式 Reducing E-R diagramstorelationalschemas 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 运用 E-R 模型进行数据库概念结构设计 Databasedesign using the E-R model 将 E-R 模型转换为关系模式 Reducing E-R diagramstorelationalschemas 难点: Focal points 运用 E-R 模型进行数据库概念结构设计，将 E-R 模型转换为关系 模式 Databasedesign using the E-R model ； Reducing E-R diagramstorelationalschemas 知识单元序号: Knowledge Unit No. 6 支撑教学目标: SLOs Supported 1-2，1-3 知识单元名称 Unit Title 关系数据设计理论 Relational database design theory 知识点: Knowledge Delivery 良好关系设计的特点: Features of good relational designs 函数依赖: Functional-dependency theory 使用函数依赖关系进行分解: Decomposition using functional dependencies 范式:Normal forms 第一范式到 BC 范式: 1NF, 2NF, 3NF, BCNF 使用函数依赖关系的分解算法: Algorithms for decomposition using functional dependencies 学习目标: Learning Objectives 了解: Recognize 多值依赖,4NF, 5NF Multivalued Dependencies; 4NF, 5NF 理解: Understand 良好关系设计的特点: Features of good relational designs

使用函数依赖关系进行分解：掌握：Decomposition using functional dependenciesMaster范式:Normalforms德育目标2-1,2-2Moral Objectives函数依赖：Functional-dependencytheory使用函数依赖关系的分解算法重点：Algorithms for decomposition using functional dependenciesKey Points第一范式到BC范式1NF, 2NF, 3NF, BCNF函数依赖：Functional-dependencytheory难点：使用函数依赖关系的分解算法Focal pointsAlgorithms for decomposition usingfunctional dependencies知识单元序号支撑教学目标：71-1, 1-4Knowledge Unit No.SLOs Supported事务处理知识单元名称Unit TitleTransactionsprocessing事务的概念：Transactionconcept一个简单的事务模型：Asimpletransactionmodel事务的原子性和持久性：Transactionatomicityanddurability知识点：事务的隔离性：TransactionisolationKnowledge Delivery可串行化：Serializability事务隔离与原子性：Transactionisolationandatomicity事务隔离级别：Transactionisolationlevels了解:事务隔离级别RecognizeTransaction Isolation Levels理解：事务的概念学习目标：UnderstandTransaction conceptLearning Objectives事务的原子性和持久性掌握：Transaction atomicity and durabilityMaster事务的隔离性：Transaction isolation可串行化：Serializability德育目标2-1,2-2Moral Objectives事务的原子性和持久性：Transactionatomicityanddurability重点：事务的隔离性：TransactionisolationKey Points可串行化：Serializability难点：可串行化：SerializabilityFocal points知识单元序号：支撑教学目标：81-1, 1-4Knowledge Unit No.SLOs Supported并发控制知识单元名称Unit TitleConcurrency control9/16

9 / 16 掌握: Master 使用函数依赖关系进行分解: Decomposition using functional dependencies 范式:Normal forms 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 函数依赖:Functional-dependency theory 使用函数依赖关系的分解算法 Algorithms for decomposition using functional dependencies 第一范式到 BC 范式 1NF, 2NF, 3NF, BCNF 难点: Focal points 函数依赖:Functional-dependency theory 使用函数依赖关系的分解算法 Algorithms for decomposition using functional dependencies 知识单元序号: Knowledge Unit No. 7 支撑教学目标: SLOs Supported 1-1，1-4 知识单元名称 Unit Title 事务处理 Transactionsprocessing 知识点: Knowledge Delivery 事务的概念:Transaction concept 一个简单的事务模型:A simple transaction model 事务的原子性和持久性:Transaction atomicity and durability 事务的隔离性:Transaction isolation 可串行化:Serializability 事务隔离与原子性:Transaction isolation and atomicity 事务隔离级别:Transaction isolation levels 学习目标: Learning Objectives 了解: Recognize 事务隔离级别 Transaction Isolation Levels 理解: Understand 事务的概念 Transaction concept 掌握: Master 事务的原子性和持久性 Transaction atomicity and durability 事务的隔离性:Transaction isolation 可串行化:Serializability 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 事务的原子性和持久性:Transaction atomicity and durability 事务的隔离性:Transaction isolation 可串行化:Serializability 难点: Focal points 可串行化:Serializability 知识单元序号: Knowledge Unit No. 8 支撑教学目标: SLOs Supported 1-1，1-4 知识单元名称 Unit Title 并发控制 Concurrency control

基本锁的协议Lock-based protocols死锁：Deadlockhandling知识点：多粒度：MultiplegranularityKnowledge Delivery插入操作、删除操作和谓词读取Insertoperations,deleteoperations,andpredicatereads时间截协议：Timestamp-basedprotocols了解:基本锁的协议:Lock-basedprotocolsRecognize插入操作、删除操作和谓词读取：理解：学习目标：Insert operations, delete operations,andpredicatereadsUnderstand时间戳协议：Timestamp-basedprotocolsLearning Objectives基本锁的协议:Lock-basedprotocols掌握：死锁:DeadlockhandlingMaster多粒度：Multiplegranularity德育目标2-1,2-2Moral Objectives重点：基本锁的协议：Lock-basedprotocolsKey Points死锁：Deadlockhandling难点：死锁：DeadlockhandlingFocal points知识单元序号：支撑教学目标：91-1, 1-4Knowledge Unit No.SLOs Supported知识单元名称数据库恢复Unit TitleRecovery system故障分类：Failureclassification数据转储：Datastorage日志文件：Logfiles恢复与原子性:Recoveryand atomicity知识点：恢复算法:RecoveryalgorithmKnowledgeDelivery缓冲区管理：Buffermanagement非易失性存储器故障：Failurewithlossofnon-volatilestorage远程备份系统：Highavailabilityusingremotebackupsystems锁释放和UNDO操作:Earlylockreleaseandlogicalundooperations了解:数据转储：DatastorageRecognize理解：故障分类：FailureclassificationUnderstand学习目标恢复与原子性:Recoveryand atomicityLearning Objectives恢复算法:Recoveryalgorithm掌握：日志文件：LogfilesMaster锁释放和UNDO操作Early lock release and logical undo operations重点：恢复与原子性:Recoveryand atomicityKey Points恢复算法:Recoveryalgorithm10 /16

10 / 16 知识点: Knowledge Delivery 基本锁的协议:Lock-based protocols 死锁:Deadlock handling 多粒度:Multiple granularity 插入操作、删除操作和谓词读取: Insert operations, delete operations, and predicate reads 时间戳协议:Timestamp-based protocols 学习目标: Learning Objectives 了解: Recognize 基本锁的协议:Lock-based protocols 理解: Understand 插入操作、删除操作和谓词读取: Insert operations, delete operations, and predicate reads 时间戳协议:Timestamp-based protocols 掌握: Master 基本锁的协议:Lock-based protocols 死锁:Deadlock handling 多粒度:Multiple granularity 德育目标 Moral Objectives 2-1,2-2 重点: Key Points 基本锁的协议:Lock-based protocols 死锁:Deadlock handling 难点: Focal points 死锁:Deadlock handling 知识单元序号: Knowledge Unit No. 9 支撑教学目标: SLOs Supported 1-1，1-4 知识单元名称 Unit Title 数据库恢复 Recovery system 知识点: Knowledge Delivery 故障分类:Failure classification 数据转储:Datastorage 日志文件:Log files 恢复与原子性:Recovery and atomicity 恢复算法:Recovery algorithm 缓冲区管理:Buffer management 非易失性存储器故障:Failure with loss of non-volatile storage 远程备份系统:High availability using remote backup systems 锁释放和 UNDO 操作:Early lock release and logical undo operations 学习目标: Learning Objectives 了解: Recognize 数据转储:Datastorage 理解: Understand 故障分类:Failure classification 掌握: Master 恢复与原子性:Recovery and atomicity 恢复算法:Recovery algorithm 日志文件:Log files 锁释放和 UNDO 操作 Early lock release and logical undo operations 重点: Key Points 恢复与原子性:Recovery and atomicity 恢复算法:Recovery algorithm