http://yunus.hacettepe.edu.tr/~tonta/courses/spring2003/dok322/d322takvim2003.htm


Hacettepe University Department of Information Management

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


Time and place: Tuesdays 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/spring2003/dok322/ 


Course Objectives and Reading List  

COURSE SCHEDULE

Week /Subject

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

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

11/03: Database analysis process; systems analysis tools

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

18/03: Entity-Relationship modeling

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

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

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

08/04: Structure and design of database management systems  

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

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

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

29/04: Database administration; (Transaction processing; Concurrency control; Recovery techniques; 06/05: Database security and management; Distributed database management)

13/05: Midterm

20/05: Future trends in database management

27/05: Wrap up (Final project due: 09:00 a.m.)


Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: Feb 25, 2003