数据库》教学大纲


课程代码

045100892

课程名称

数据库

英文名称

Database

课程类别

专业基础课

课程性质

必修

学时

总学时:64 实验学时:16 实习学时:0其他学时:0

学分

3.5

开课学期

第四学期

开课单位

计算机科学与工程学院

适用专业

计算机科学与技术、网络工程、信息安全

授课语言

中文授课

先修课程

计算机组成和体系结构、高级语言程序设计

课程对毕业要求的支撑

本课程对学生达到如下毕业要求有如下贡献:

3.设计/开发解决方案:能够设计针对复杂与计算机相关工程问题的解决方案,设计满足特定需求的系统、单元(部件)或工艺流程,并能够在设计环节中体现创新意识,考虑社会、健康、安全、法律、文化以及环境等因素。

4.研究:能够基于科学原理并采用科学方法对与计算机相关复杂工程问题进行研究,包括设计实验、分析与解释数据、并通过信息综合得到合理有效的结论。

5.使用现代工具:能够针对与计算机相关复杂工程问题,开发、选择与使用恰当的技术、资源、现代工程工具和信息技术工具,包括对复杂工程问题的预测与模拟,并能够理解其局限性。

课程目标


完成课程后,学生将具备以下能力:

1)掌握数据库的基本原理和基本知识,培养学生发现问题、解决问题的基本能力。[3

2)能使用SQL语言进行基本数据操作,学生具有使用和维护一个一般数据库系统的基本能力。[3

3)掌握逻辑数据库设计和物理数据库设计为核心的规范设计方法,具有设计、使用一个一般数据库系统的基本能力, 具备初步开发数据库应用软件的基本能力。[345

课程简介

本课程主要讲述数据库系统的基本原理、实现技术和应用技术,包括关系数据库理论、数据库语言、数据库设计及数据库系统实现等几个方面。通过学习这门课程,达到熟练应用数据库,掌握数据库的内部原理和运行过程,了解数据库技术的最新发展动态的目的。

教学内容与学时分配


(一)绪论          4学时

  1. 数据库系统概述                              1学时

  2. 数据模型                                    1学时

  3. 数据库系统结构                              1学时

  4. 数据库系统的组成                            1学时

教学要求:

1)    掌握课程的主要目的与任务,了解数据库在国民经济中的作用。

2理解数据、数据库、数据库管理系统和数据库系统的概念。

3掌握数据库系统的特点,数据库系统的结构。

4掌握概念模型、数据模型的相关概念,了解常用的数据模型。

(二)关系数据库     5学时

  1. 关系数据结构及形式化定义                  1学时

  2. 关系操作                                  1学时

  3. 关系的完整性                              1学时

  4. 关系代数                                  2学时

教学要求:

1掌握关系、关系模式、关系数据库、关系代数。    

2理解关系的完整性。

(三)关系数据库标准语言SQL     9学时

  1. SQL概述                                0.5学时

  2. 数据定义                                1.5学时

  3. 查询                                     5学时

  4. 数据更新                                 1 学时

  5. 视图                                     1学时

教学要求:

1理解SQL语言的概念、特点、功能和使用方法。

2掌握SQL基本语句的使用。

重点:查询语句的使用,包括连接查询和嵌套查询。

(四)数据库安全性            2学时

  1. 计算机安全性概论                       0.2学时

  2. 数据库安全性控制                        1学时

  3. 视图机制                               0.1学时

  4. 审计                                   0.2学时

  5. 数据加密                               0.2学时

  6. 其他安全性保护                         0.3学时

教学要求:

1理解计算机安全性概念。

2掌握数据库安全性控制。

(五)数据库完整性           2学时

  1. 实体完整性                            0.2学时

  2. 参照完整性                            0.2学时

  3. 用户定义的完整性                      0.2学时

  4. 完整性约束命名子句                    0.2学时

  5. 触发器                                1.2学时

教学要求:

1理解数据库完整性控制的基本概念与方法。

2了解关系数据库中定义完整性约束的方法。

(六)关系数据理论       6学时

  1. 问题的提出                           1学时

  2. 规范化(1BCNF)                   2学时

  3. 数据依赖的公理系统                   2学时

  4. 模式分解                             1学时

教学要求:

  1. 掌握函数依赖、码、范式、2NF3NFBCNF概念与判别。

  2. 了解保持函数依赖并具有无损连接性的3NF模式分解算法。

(七)数据库设计          6学时

  1. 数据库设计概述                      0.25学时

  2. 需求分析                            1学时

  3. 概念结构设计                        1.25学时

  4. 逻辑结构设计                        1.25学时

  5. 数据库的物理设计                    1.25学时

  6. 数据库的实施和维护                  1学时

教学要求:

  1. 理解数据库设计的特点、方法、步骤。

  2. 掌握需求分析、概念结构设计、逻辑结构设计。

(八)数据库编程        4学时

  1. 嵌入SQL                             1学时

  2. 过程化SQL                           0.5学时

  3. 存储过程和函数                       1学时

  4. ODBC编程                           1学时

  5. JDBC编程                            0.5学时

教学要求:

  1. 了解嵌入式SQL和动态SQL技术。

  2. 掌握存储过程和函数

  3. 掌握ODBC编程 。

(九)关系查询处理和查询优化    4学时

  1. 关系数据库系统的查询处理              1学时

  2. 关系数据库系统的查询优化              1学时

  3. 代数优化                              1学时

  4. 物理优化                              1学时

教学要求:

  1. 掌握关系系统查询优化的一般准则。

  2. 了解关系代数等价变换规则。

  3. 了解物理优化的原理和方法

(十)数据库恢复技术        2学时

  1. 事务的基本概念                         0.25学时

  2. 数据库恢复概述                         0.25学时

  3. 故障的种类                             0.25学时

  4. 恢复的实现技术                         0.5学时

  5. 恢复策略                               0. 25学时

  6. 具有检查点的恢复技术                   0.25学时

  7. 数据库镜像                             0.25学时

教学要求:

  1. 掌握事务的基本概念

  2. 理解故障的种类及相应的恢复策略。

(十一)并发控制              4学时

    1. 并发控制概述                            0.25学时

    2. 封锁                                    0.5学时

    3. 封锁协议                                1学时

    4. 活锁和死锁                              0.5学时

    5. 并发调度的可串行性                      1学时

    6. 两段锁协议                              0.5学时

    7. 封锁的粒度                              0.25学时

教学要求:

  1. 掌握封锁、封锁协议、活锁死锁。

掌握并发调度的可串行性。

实验教学(包括实验学时、实习学时、其他)

教学方法

课程教学以课堂教学、课外作业、上机实验、单元测试、课程设计等教学方法等共同实施。

考核方式

本课程注重过程考核,成绩比例为:

平时作业、实验和课堂表现:20%

平时上机测试:30%

期末考试(闭卷):50%

教材及参考书

现用教材:王珊主编,数据库系统概论(第五版),高等教育出版社,2014.9

主要参考资料:

杨冬青主编,数据库系统概念(第六版),机械工业出版社,2012.3

制定人及制定时间

董守玲,2019410


  “Database” Syllabus

Course Code

045100892

Course Title

Database

Course Category

Specialty Basic Courses

Course Nature

Compulsory Course

Class Hours

Class Hours: 64  Lab Hours: 16  Practice: 0  Other: 0

Credits

3.5

Semester

Forth

Institute

School of Computer Science and Engineering

ProgramOriented

Computer Science and Technology, Network Engineering, and Information Security

Teaching Language

Chinese

Prerequisites

Computer Composition, Computer Architecture, and Advanced Language Programming Design

 Student Outcomes

 (Special Training Ability)

  1. Design / Development Solutions: An ability to design solutions for complex engineering problems and innovatively design systems, components or process that meet specific needs with societal, public health, safety, legal, cultural and environmental considerations.

  2. Research: An ability to conduct investigations of complex engineering problems based on scientific theories and adopting scientific methods including design of experiments, analysis and interpretation of data and synthesis of information to provide valid conclusions.

  3. Applying Modern Tools: An ability to create, select and apply appropriate techniques, resources, and modern engineering and IT tools, including prediction and modeling, to complex engineering activities, with an understanding of the limitations.

Course Objectives

  1. Understand basic principles and knowledge of database and to discover and solve problems.[3]

  2. Use SQL language to conduct basic data manipulation, use and maintain a general database system.[3]

  3. Design and use a general database system and develop database application software; know standard design methods which regard logic and physic database as core.[3,4,5]

Course Description

This course focuses on interpreting basic principles, implementation technique, and application technology, which include theories of relational database, database language, database design, and database system development, etc. Students who complete this course will be capable of using database, knowing the internal principles and operating process of database, and understanding latest trend of development of database technology.

Teaching Content and Class Hours Distribution

  1. Introduction    4 Class Hours

  1. Overview of database system                        1 Class Hour  

  2. Data model                                      1 Class Hour

  3. System structure of database                         1 Class Hour

  4. Composition of database system                      1 Class Hour

Teaching requirements:

  1. Understandthe main objectives and tasks of the course, and understand the role of the database in the national economy.

  2. Understand concept of data, database, database management system, and database system.

  3. Know features and structure of database system.

  4. Understand related knowledge about concept model and data model as well as get to know most used data model.

  1. Relational database    5 Class Hours

  1. Structure and formalized definition of relational database. 1 Class Hour

  2. Relational operation.                              1 Class Hour

  3. Integrity of relation.                               1 Class Hour

  4. Relation algebra.                                  2 Class Hour

Teaching requirements:

  1. Understand relation, relation pattern, relational database, and relation algebra.

  2. Understand integrity of relation.

  1. SQL : Standard language of relational database    9 Class Hours

  1. SQL overview                                   0.5 Class Hour

  2. Definition of data                                1.5 Class Hour

  3. Search                                         5 Class Hours

  4. Data upgrade                                     1 Class Hour

  5. View                                           1 Class Hour

 Teaching requirements:

  1. Understand concept, features, function of SQL and know how to use it.

  2. Students are able to use basic SQL language.

 Key point: Search SQL sentences, including Join and Nested search.

  1. Database security    2 Class Hours

  1. Overview of computer security                     0.2 Class Hour

  2. Control of database security                        1 Class Hour

  3. Mechanism of View                              1 Class Hour

  4. Audit                                          1 Class Hour

  5. Data Encryption                                 1 Class Hour

  6. Other security measures                           0.3 Class Hour

 Teaching requirements:

  1. Understand concept of computer security.

  2. Grasp database security control.

  1. Database integrity    2 Class Hour

  1. Entity integrity                                 0.2 Class Hour

  2. Referential integrity                             0.2 Class Hour

  3. Integrity of customer’s definition                   0.2 Class Hour

  4. Name sub-sentence of integrity constraints           0.2 Class Hour

  5. Trigger                                       1.2 Class Hours

 Teaching requirements:

  1. Understand basic concept and method of database integrity control.

  2. Know how to define constraints in relational database.

  1. Theory of relational database    6 Class Hours

  1. Problems                                       1 Class Hour

  2. Regularization(1-BCNF)                           2 Class Hours

  3. Axiom system that data relies on                     2 Class Hours

  4. Pattern decomposition                             1 Class Hour

 Teaching requirements:

  1. Grasp concept and distinct of function dependency, code, BNF, 2NF, 3NF, and BCNF.

  2. Understand pattern decomposition method of 3NF which allows maintaining function dependency while holding lossless join.

  1. Database design     6 Class Hour

  1. Overview of database design                     0.25 Class Hour

  2. Requirements analysis                          1 Class Hour

  3. Conceptual structure design                      1.25 Class Hours

  4. Logic framework design                        1.25 Class Hours

  5. Physic design                                 1.25 Class Hours

  6. Implementation and maintenance of database        1 Class Hour

 Teaching Requirements:

  1. Understand features, methods, and steps of database design.

  2. Know requirements analysis, conceptual structure design, and logic framework design.

  1. Database programming    4 Class Hour

(1 ) Embedded SQL                                   1 Class Hour

(2) Procedural SQL                                  0.5 Class Hour

(3) Procedures and function                            1 Class Hour

(4) ODBC programming                              1 Class Hour

(5) JDBC programming                              0.5 Class Hour

Teaching Requirements:

  1. Know techniques of embedded SQL and dynamic SQL.

  2. Grasp procedures and function.

  3. Master ODBC programming.

  1. Relational search and optimization   4 Class Hours

  1. Search process of relational database system            1 Class Hour

  2. Search optimization                               1 Class Hour

  3. Algebra optimization                              1 Class Hour

  4. Physic optimization                               1 Class Hour

   Teaching requirements:

  1. Know general principles of search optimization in relational system.

  2. Understand rules of equivalent transformation of algebra.

  3. Grasp principles and methods of physic optimization.

  1. Database recovering technique   2 Class Hours

  1. Basic concept of Action                          0.25 Class Hour

  2. Overview of database recovering                   0.25 Class Hour

  3. Types of malfunction                            0.25 Class Hour

  4. Recovering techniques                           0.5 Class Hour

  5. Recovering strategy                             0.25 Class Hour

  6. Recovering by using check points                  0.25 Class Hour

  7. Database mirror                                0.25 Class Hour

 Teaching requirements:

  1. Master basic concept of Action.

  2. Know categories of malfunction and relevant recovering stratefy.

  1. Concurrency control    4 Class Hours

  1. Overview of concurrency control                  0.25 Class Hour

  2. Lock                                        0.5 Class Hour

  3. Lock protocols                                1 Class Hour

  4. Livelock and deadlock                          0.5 Class Hour

  5. Concurrency dispatch and serializability            1 Class Hour

  6. TwoPhase lock protocol                         0.5 Class Hour

  7. Granularity                                   0.25 Class Hour

 Teaching requirements:

  1. Grasp lock, lock protocol, and livelock and deadlock.

  2. Know serializability of concurrency dispatch.

Experimental Teaching

Included

Teaching Method

Mainly depends on class lecturing while in combination with homework, computer-aided experiment, unit test, and course project.

Examination Method

Emphasize process assessment, grading strategy:

Homework, experiments, and performance in class accounts for 20%;

Computer-aided tests accounts for 30%;

Final exam(Closed book/notes): 50%

Teaching Materials and Reference Books

Textbook in use: Wang Shan(Editor-in-chief), An Introduction to Database(Fifth edition), published by Higher Education Press, 2014.09

References:

Prepared by Whom and When

Shouling DONG, 2019.04.10


《数据库》实验教学大纲

课程代码

045100892

课程名称

数据库

英文名称

Database

课程类别

专业基础课

课程性质

必修

学时

总学时:64 实验:16 实习:0 其他:0

学分

3.5

开课学期

第四学期

开课单位

计算机科学与工程学院

适用专业

计算机科学与技术、网络工程、信息安全

授课语言

中文授课

先修课程

计算机组成和体系结构、高级语言程序设计

毕业要求(专业培养能力)

本课程对学生达到如下毕业要求有如下贡献:

3.设计/开发解决方案:能够设计针对复杂与计算机相关工程问题的解决方案,设计满足特定需求的系统、单元(部件)或工艺流程,并能够在设计环节中体现创新意识,考虑社会、健康、安全、法律、文化以及环境等因素。

4.研究:能够基于科学原理并采用科学方法对与计算机相关复杂工程问题进行研究,包括设计实验、分析与解释数据、并通过信息综合得到合理有效的结论。

5.使用现代工具:能够针对与计算机相关复杂工程问题,开发、选择与使用恰当的技术、资源、现代工程工具和信息技术工具,包括对复杂工程问题的预测与模拟,并能够理解其局限性。

课程培养学生的能力(教学目标)

1.通过交互式SQL的使用, 掌握数据库的创建、插入、更新、查询等操作。

2.通过创建视图、触发器,设计安全机制等方式掌握数据库的安全和完整性的设计。

3.学会创建存储过程。

4.通过编写事务隔离级别的测试程序了解事务并发控制机制。

5.学会进行数据库的备份与恢复。

课程简介

本课程是计算机专业的专业必修课。实验教学的目的是通过上机实验的实践锻炼,使学生加深对所学理论知识的理解,学会使用数据库,并能设计简单的数据库应用程序。

主要仪器设备与软件

PC机,数据库管理系统软件

实验报告

实验报告要包含“实验目的及要求“、“实验过程(实验步骤、实验数据)”和“小结”

考核方式

实验操作(30%)+实验报告(40%)+预习、考勤、实验纪律(30%)

教材、实验指导书及教学参考书目

实验指导书:自编

参考书:杨海霞 主编.  《数据库实验指导》.人民邮电出版社. 2007

制定人及发布时间

董守玲   2019410


《数据库》实验教学内容与学时分配

实验项目编号

实验项目名称

实验学时

实验内容提要

实验类型

实验要求

每组人数

主要仪器设备与软件

1

交互式SQL的使用

4

通过交互式SQL的使用, 掌握数据库的创建、插入、更新、查询等操作

设计性

必做

1

PC机,数据库管理系统软件

2

数据库的安全和完整性约束

4

通过创建视图、触发器,设计安全机制等方式掌握数据库的安全和完整性的设计

设计性

必做

1

PC机,数据库管理系统软件

3

SQL编程

4

学会创建存储过程

设计性

必做

1

PC机,数据库管理系统软件

4

事务的管理

4

通过编写事务隔离级别的测试程序了解事务并发控制机制

学会进行数据库的备份与恢复

设计性

必做

1

PC机,数据库管理系统软件


 “Database” Syllabus

Course Code

045100892

Course Title

Database

Course Category

Specialty Basic Courses

Course Nature

Compulsory Course

Class Hours

Total Class Hours: 64  Lab Hours: 16

Credits

3.5

Semester

Fourth

Institute

School of Computer Science and Engineering

Program Oriented

Computer Science and Technology, Network Engineering, and Information Security

Teaching Language

Chinese

Prerequisites

Computer Composition, Computer Architecture, and Advanced Language Programming Design

Student Outcomes (Special Training Ability)

3. Design / Development Solutions: An ability to design solutions for complex engineering problems and innovatively design systems, components or process that meet specific needs with societal, public health, safety, legal, cultural and environmental considerations.

4. Research: An ability to conduct investigations of complex engineering problems based on scientific theories and adopting scientific methods including design of experiments, analysis and interpretation of data and synthesis of information to provide valid conclusions.

5. Applying Modern Tools: An ability to create, select and apply appropriate techniques, resources, and modern engineering and IT tools, including prediction and modeling, to complex engineering activities, with an understanding of the limitations.

Teaching Objectives

  1. By using interactive SQL, master CRETAE, INSERT, UPGRADE, and SEARCH sentences.

  2. By creating view, trigger, and designing security mechanism, master security and integrity design of database.

  3. Know how to create procedures.

  4. By writing test program of transaction isolation level, know concurrency control mechanism of action.

  5. To know backup and recovery mechanism of database.

Course Description

This course is compulsory for students major in computer. Experiment teaching aims at reinforcing students’ understanding of learned theories, knowing how to deal with database, and developing simple database application through computer-aided experiments.

Instruments and Equipments

PC, Database management system software.

Experiment Report

Includes “Content and requirement of experiment”, “process (steps and data)”, and “summarization”.

Assessment

Experimental operation (30%) + experiment report (40%) + preview, attendance, and experiment discipline (30%)

Teaching Materials and Reference Books

Guide books for experiment: Self-edit.

Reference: Yang Haixia (Editor-in-chief), Guide of Database Experiment, published by Posts and Telecom Press, 2007.

Prepared by Whom and When

Shouling DONG, 2019.4.10

 “Database” Experimental Teaching Arrangements

No.

Experiment Item

Class Hours

Content Summary

Category

Requirements

Number of StudentsEach Group

Instruments, Equipments and Software

1

Use of Interactive SQL

4

By using interactive SQL, master CRETAE, INSERT, UPGRADE, and SEARCH sentences.


Design

Compulsory

1

PC, Database management system software

2

Security and Integrity Constraints of database

4

By creating view, trigger, and designing security mechanism, master security and integrity design of database

Design

Compulsory

1

PC, Database management system software

3

SQL Programming

4

Know how to create procedures

Design

Compulsory

1

PC, Database management system software

4

Action Management

4

By writing test program of transaction isolation level, know concurrency control mechanism of action.

Know how to backup and recovery of database.

Design

Compulsory

1

PC, Database management system software