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