Introduction to Database Theory

• Teacher

– Prof. Yuen-Hsien Tseng

– Office: 綜合大樓10樓

– Tel: 23215131 ext 604

– E-mail: samtseng@ntnu.edu.tw

– Homepage: http://web.ntnu.edu.tw/~samtseng/

• Time of course

              09:10~12:00 Tuesday

• Score

- Exam: midterm: 30%     Quiz: 15%

- Homework: 25%        - Project: 30%   

• Textbook

– “Fundamentals of Database Systems,” Fourth Edition,

Elmasri and Navathe, Addison Wesley (開發代理, Tel:82423988)

• Reference book

-   “A First Course in Database Systems,” Second Edition,

Jeffrey D. Ullman and Jennifer Widom, Prentice Hall (全華代理)

• Course Schedule (only for reference)

– 02/21    Introduction

– 02/28    National Holiday

– 03/07  Relational Model

– 03/14    Relational Algebra

– 03/21    SQL

– 03/28    DB Programming

– 04/04    Holiday

– 04/11    ER Model

– 04/18    Database Design

– 04/25    Dependencies, Normalization    （Project Report 1 due）

– 05/02    Mid-Term Exam

– 05/09    File Organization and Indexing

– 05/16    Query Processing and DB Tuning

– 05/23    Transactions, Concurrency, Recovery（Project Report 2 due）

– 05/30    Object-Oriented and Object-Relational DBMS

– 06/06    XML

– 06/13  Case Study

– 06/20    Project Demo & Final Report due