《数据库原理》(双语)教学大纲_English

《Database Principles》

Course Syllabus

1、Course Number:040305

2、Course Type: Optional-limited

Course periods: 32 hours (Theoretical 24 / Practical 8)

Supported Majors: Communication Engineering，Electronic and Information Engineering，Electronic Information Science and Technology，Information Engineering

Pre-Course: Introduction to Computer Science，C Programming Language

3、Course Quality and Mission

Database technology has become the core technology and an important base of computer information systems and application systems. Database Principles is a backbone course of Computer Science & Engineering and other related disciplines. Through the study of theory and practice in this course, students should grasp the basic concept of database systems and basic theory. Besides, we should focused on the study of relations between the relevant content database system, use SQL proficiently, master the theories and methods of designing database, master basic skills of database systems operation and maintenance, understanding of database technology developments.

4、Teaching Outlines and Periods

4.1 The worlds of database system (2 hours)

4.1.1 Data Management Technology and Development

4.1.2 Basic Concept of Database System

4.1.3 Architecture of Database System and Application System

4.1.4 Contents of Database System

4.2 Database Models (2 hours)

4.2.1 Information Modeling Period

4.2.2 Concept Model and Data Model

4.2.3 Entity/Relationship Model

4.3 Relational Data Model (4 hours)

4.3.1 Foundation of Relational Model

4.3.2 Methods of Transforming E-R Model to Relational Model

4.3.3 Relation Decomposing Theories and Methods

4.3.4 Data Dependence

4.3.5 Database Design

4.4 Relational Algebra (2 hours)

4.4.1 Relational Algebra Languages

4.4.2 Characteristics/operator/ expression of Relational Algebra

4.5 Standard Relational Database Language: SQL (6 hours)

4.5.1 Characteristics of SQL

4.5.2 Data Definition Statements

4.5.3 Data Query Statements

4.5.4 Data Update Statements

4.5.5 Definition and Use of View

4.5.6 Data Control Method

4.6 Transactions Management (2 hours)

4.6.1 Concept and Characteristics of Transaction

4.6.2 Database Recovery Technology

4.6.3 Database Concurrency Control Technology

4.7 Developing Platform and Tools (2 hours)

4.7.1 Database Security and Control Method

4.7.2 Integrality Constraints and Control

4.8 Latest Database Technology (4 hours)

4.8.1 Trend of Database System

4.8.2 Application Fields of Database

5、Basic Teaching Requirements

The theoretical knowledge and practical ability of this course are both important, and has good application background. Through studying of theoretical and practical knowledge, the basic teaching requirements for the students are divided into three levels:

5.1 Master: Belonging to the higher demand, the master of content should be more thorough understanding, can analysis and handle problems skillfully in the real