http://yunus.hacettepe.edu.tr/~tonta/courses/spring2004/dok322/d322takvim2004.htm


Hacettepe University Department of Information Management

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


Time and place: Mondays 09:10-13:00 (B8 1K 102)

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

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


Course Objectives and Reading List  

COURSE SCHEDULE

Week /Subject

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

23/02: Case studies of database applications; Introduction to Microsoft Access 2000

1/03: Database analysis process; systems analysis tools

Homework: Cookie and Northwind databases. Both are due on March 29, 2004 9:00 am.

8/03: Entity-Relationship modeling

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

15/03: Entity-Relationship modeling (cont’d); Database design process; case studies

22/03: Logical database design; Relational database design; Normalization

29/03: Structure and design of database management systems  (Cookie and Northwind assignments due: 09:00 a.m.)

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

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

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

19/04: Database administration; (Transaction processing; Concurrency control; Recovery techniques;

26/04: Database security and management; Distributed database management)

03/05: Midterm

10/05: Future trends in database management  (Final project due: 09:00 a.m.)

17/05: Wrap up


Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: Feb 19, 2004