http://yunus.hacettepe.edu.tr/~tonta/courses/spring2002/dok322/d322takvim2002.htm


Hacettepe University Department of Library Science

DOK 322 Database Management Systems (Spring 2002) 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/spring2002/dok322/ 


Course Objectives and Reading List  

COURSE SCHEDULE

Week /Subject

26/02: Introduction to Course; Basic database concepts; file management vs. database management systems

05/03: Case studies of database applications; Introduction to Microsoft Access 2000

12/03: Database analysis process; systems analysis tools

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

19/03: Entity-Relationship modeling; Database design process; case studies

Homework: Cookie Entity-Relationship (E-R) Diagram. Due in class on April 2, 2002 9:00 am.

26/03: Library Week: No class

02/04: Logical database design; Relational database design; Normalization (Cookie and Northwind assignments due: 09:00 a.m.)

09/04: Structure and design of database management systems  

16/04: Physical database design; Usage and analysis; Indexing

23/04: Holiday: No class

30/04: Query and data manipulation languages; Relational algebra; SQL; MS Access QBE

Final Project: due on May 24, 2002 10:00 a.m.)

07/05: Midterm

14/05: Database administration; (Transaction processing; Concurrency control; Recovery techniques;

                                Database security and management; Distributed database management)

21/05: Future trends in database management and Wrap up (Final project due: 09:00 a.m.)


Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: May 14, 2002