資料庫系統
Database Systems

 

劉瑞瓏
Rey-Long Liu

2018/2/26

 

 

Goal:

This course introduces the basic concepts of database systems. By project report, implementation, and case study, this course also introduces students to the basic design principles and applications of database systems.

Prerequisite:

None (Programming is suggested).

Content:

Part I: Introduction

(1) Introduction to database systems

Part II: Part II: Database Modeling

(2) Modeling Data in the Organization (I)

(3) Modeling Data in the Organization (II)

(4) The Enhanced E-R Model

(5) Project report and discussion (I)

Part III: Database Design

(6) Logical Database Design and the Relational Model (I)

(7) Logical Database Design and the Relational Model (II)

(8) Project report and discussion (II)

(9) Midterm examination

(10) Physical Database Design and Performance (I)

(11) Physical Database Design and Performance (II)

(12) Project report and discussion (III)

Part IV: Database Implementation

(13) Introduction to SQL (I)

(14) Introduction to SQL (II)

(15) Introduction to SQL (III)

(16) Project report and discussion (IV)

(17) Data Warehousing

(18) Final examination

Grading:

(1) Project report: Written part (50%), Oral part (10%)

(2) Midterm examination (20%)

(3) Final examination (20%)

Textbook:

Hoffer J. A., Venkataraman H., Topi H. (2016).“Modern Database Management (12/E),” Pearson Education Limited.

Materials:

The e-learning system in Tzu Chi University: the Moodle system

Back to Teaching