课程号：

TS196014

课程名：

在线交易处理系统的数据库塑造与设计

英文课程名：

Database Modelling and Design for OLTP Systems

开课单位：

本科生院

授课教师：

Prof.Dr.Christian Rich

责任教师：

助理教师：

学分/学时：

1/16

选课年级：

大一起

选课专业：

计算机科学、经济信息系统等相关专业

教师简介（中英文）：

Rich教授出生于1962年，1989年达姆施达特工业大学计算机专业毕业，1994年在瑞士联邦理工学院和德国乌尔姆大学任职为科研助理并获得数据库与信息系统方向博士学位。之后在德意志银行和多个IT公司担任科研与管理工作，曾被任命为德意志银行副行长。2003年被法兰克福应用科技大学聘请成为计算机科学教授，并担任商业信息系统方向教学主任一职。至今作为客座教授和访问学者分别去过浙江科技大学、纳米比亚科技大学与越南德国大学。科研重点方向为“新一代数据库与信息系统”。

Professor Rich was born in 1962. He graduated with a computer degree from the Technical University of Darmstadt in 1989. In 1994, he worked as a research assistant at the Swiss Federal Institute of Technology and Ulm University in Germany and obtained a Ph.D. in database and information systems. He then worked as a research and management manager at Deutsche Bank and several IT companies and was appointed Vice President of Deutsche Bank. In 2003, he was hired as a professor of computer science at the University of Applied Sciences in Frankfurt, and served as the director of the direction of business information systems. As a visiting professor and visiting scholar, he has been to Zhejiang University of Science and Technology, Namibia University of Science and Technology and the German University of Vietnam. The focus of research is “Next Generation Database and Information System”.

课程简介（中英文）：

课程内容：

数据库非常普遍，并且几乎可以在任何维护一定数量持久性信息的IT系统中发挥关键作用。这个课程模块传达计算机科学学科的核心能力，这将使学生有资格进行关系数据库的数据库建模和设计。

完成学科后，学生就可以:

-举例说明良好的数据库设计的重要性

-使用实体关系模型执行需求分析和概念数据建模。

-将概念数据模型转换为关系数据库模式

-使用标准数据库语言SQL实现数据库模式

Databases are incredibly prevalent and play a key role in just about any IT system that maintains some amount of persistent information. This module conveys core competencies in the discipline of computer science, which will qualify students to perform database modelling and design for relational databases.

Upon completion of the module the student is able to：

-Exemplify the importance for a good database design

-Perform requirements analysis and conceptual data modelling using the Entity Relationship Model.

-Transform the conceptual data model to a relational database schema

-Implement the database schema using the standard database language SQL

先修课程：

建议有软件工程基础知识，但不必须