http://yunus.hacettepe.edu.tr/~tonta/courses/spring2001/dok322/d322takvim2001.htm/


Hacettepe University Department of Library Science

DOK 322 Database Management Systems (Spring 2001) Yaşar Tonta


Time and place: Tuesdays 09:10-13:00 (B8 1K 104)

Instructor: Yaşar Tonta (e-mail: tonta@hacettepe.edu.tr; tel: 297 82 04) 

Course web site: http://yunus.hacettepe.edu.tr/~tonta/courses/spring2001/dok322/ 


Course Objectives and Reading List  

COURSE SCHEDULE

Week /Subject

 

1             Introduction to Course; Basic database concepts; file management vs. database management systems (20/2)

2                  Case studies of database applications; Introduction to Microsoft Access 97 (27/2)

               6/3 Holiday

3                  Database analysis process; systems analysis tools (13/3)

Homework: Cookie and Northwind databases. Both are due on April 3, 2001 9:00 am.

20/3 No class

4             Entity-Relationship modeling; Database design process; case studies (27/3) (Library Week)

5             Logical database design; Relational database design; Normalization (3/4)

6             Structure and design of database management systems (Your database homework) (10/4)

7             Physical database design; Usage and analysis; Indexing (17/4)

8             Query and data manipulation languages; Relational algebra; SQL; MS Access QBE (24/4)

9             Midterm (1/5)

10           Database administration; (Transaction processing; Concurrency control; Recovery techniques; Database security and management; Distributed database management) (8/5)

11           Future trends in database management (15/5)
12          
Wrap up


Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: Feb 18, 2001