Course Name: Database Systems

Course Code: S2293197

Semester:2

Credit: 3

Program: Computer Science

Course Module: Specialized Compulsory

Responsible: Xin Wang

E-mail: wjr@tju.edu.cn

Department: School of Computer Science & Technology, Tianjin University

Time Allocation (1 credit hour = 45 minutes)

Course Description

The course is a required course designed for Engineering Master of Computer Science in TIEI and a course with very intense practicality, which contains the basic principle and programming of database. Students could design and implement a relational database and database applications according to the needs of department or business, based on having mastered the basic principle and methods of designing a database. This course offers knowledge about designing, constructing and managing database respectively from theory and practice. Students will have a preliminary and extensive understanding about relational database, which enables students to develop relational database.

Prerequisite

Understanding of the basic concepts and theories of computer operation principle,

Deep understanding of information theory, statistics, cryptography and stochastic model, and the use of related tools,

Mastery of the form of processing data in Computer Mathematics, and to

Understand modeling methods, the model’s advantages and disadvantages, and how to carry out and improve the model.

Course Objectives

This course discusses basic concepts of Relational Database to help students understand database better. After this course, students should be able to:

Master basic knowledge of database principle,

Understand how to design and construct relational database,

Understand the differences between each paradigm, and could apply them in practice, and to

Design and construct database independently, then can query data from database, and manage the database.

Course Syllabus

Relational Database overview: The development history and basic knowledge,

Data model: model types, relational algebra, relational integrity,

ER model: conceptual model, ER analysis method and application,

Paradigm Analysis: data dependence, function dependency, paradigm,

SQL language: introduction, data query, data manipulation, data definition statements, data control statements,

The use of common database objects: views, stored procedures, triggers, and cursor

Index and query: index and index in query system, and to

Data processing: common types of transactions, transaction isolation levels.

Textbooks & References

• Hector Garcia-Molina, Jeff Ullman, Jennifer Widom.Database Systems: The Complete Book. Pearson Prentice Hall, 2008.

• Jeffrey D. Ullman, Jennifer Widom.First Course in Database Systems. Prentice Hall, 1998.

• Sridhar Avantsa, Tariq Farooq, Pete Sharman.Building Database Clouds in Oracle 12c. Addison-Wesley Professional, 2015.

• Lev Manovich, Andreas Kratky.Soft Cinema: Navigating the Database. MIT Press, 2005.

Capability Tasks

CT2: To master the basic concepts of Relational Database.

CT3: To master the implementation methods of SQL Server language and triggers.

CT4: To have the ability of designing database and managing affairs with SQL Server language.

CS1: To master the basic theories of Relational Database, and know the status and development trends of the Relational Database.

CS2: To master the core knowledge of the database roundly, such as relational model, indexes, paradigms and so on; have the preliminary ability of designing databases.

CS3: To have a good ability in developing databases, and be able to participate in constructing databases.

Achievements

To understand the development of data management technology, database’s basic concept, data model and structure of the database management system. - Level: A

To design and construct relational database. - Level: M

To use different paradigm according to different actual requirement in the practice. - Level: M

Database query and management. - Level: M

Students: Computer science ,Year 1