ITEC521 Database

Instructor Gary Geunbae Lee, gblee@postech.ac.kr

1. Course Objectives

This course focuses on the basic concepts necessary for designing, using and implementing database systems and applications. Students will learn about database modeling and design, the languages provided by database management systems, and important system implementation techniques.

2. Pre-requsities

No prerequisites are required

3. Grading

Midterm 40%
Final 40%
Class participation 20%

4. Textbook and references

Silberschatz, Korth and Sudarshan. Database system concepts, 5th edition, McGraw-Hill International editions, May 2005 (main text)

C. J. Date, An introduction to database systems, 6th edition. Addison Wesley publishing company, 1995 (somewhat old, but still very useful) * you don’t need to buy it

5. Course schedules

- Introduction (chap 1)
- Storage and file structure (chap 11)
- index and hashing (chap 12)
- relational model (chap 2)
- SQL (chap 3)

- Query Processing (chap 13)
- data base design: ER approach (chap 6)
- relational database design (chap 7)
- Midterm exam with review
- application design (chap 8)
- XML (chap 10)
- Transactions (chap 15)
- concurrency control (chap 16)
- recovery systems (chap 17)

- Data analysis and mining (chap 18)

- Information retrieval (chap 19)
- Final exam

6. Notes

Instruction language is Korean. When foreign students are in the class, the course can be taught in English.