http://yunus.hacettepe.edu.tr/~tonta/courses/spring2002/dok322/d322dersamac2002.htm/
Hacettepe University Department of Library Science
DOK 322 Database Management Systems (Spring 2002) Yaşar Tonta
Time and place: Tuesday 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/spring2002/dok322/
Goals: This course is concerned with the application of
Database Management Systems (DBMS) to solve a wide range of information storage
and retrieval problems, particularly in libraries and information centers. We will combine the practical aspects of DBMS
use with more theoretical discussions of database design methodologies and the
“internals” of database systems.
The
major work in the course will be practical: you will re-design Cookie database
so as to improve it. In the theoretical
portion of the course we will examine the major types, or “data models,” of
DBMS (hierarchical, network, and relational).
We will discuss the principles and problems of database design,
operation, and maintenance for each data model.
Assignments: Most of the assignments in this course will be
related to Cookie database to familiarize you with the systems that you will be
using in library environments. A second
set of assignments will involve the use of existing databases (Cookie and
Northwind) to answer a set of queries, or to modify the database. We will discuss these assignments further in
class.
It
should be obvious that you will need to spend a lot of time in the Department’s
Microcomputer Lab.
Readings: There are two sets of readings included in the
course outline: theoretical and practical.
They are listed in the syllabus.
Grades: Grades for this course will be based on completion
of the assignments, midterm, and participation in class discussions.
Texts: The required textbook for the course is:
Kroenke,
David M. Database Processing: Fundamentals, Design, and Implementation.
6th Edition. Upper
Saddle River, NJ: Prentice Hall, 1998.
I will share my copy with you and
make the needed chapters available for xeroxing. An older edition (1990) of
this book can be found at Bilkent University Library Reserve collection.
Some of the recommended sources are
as follows:
Atre, S. Data
Base: Structured Techniques for Design, Performance, and Management.
New York: Wiley, 1980.
Elmasri, Ramez and Shamkant B. Navathe. Fundamentals of Database Systems. Second Edition. Redwood City, Calif.: Benjamin/Cummings Pub. Co.,
1994.
McFadden, F.R. and J.A. Hoffer, Data Base Management. (2d ed.) Menlo
Park, CA:
Benjamin Cummings
Publishing Co., 1988. (1994 edition can also be found)
You can find several
books on Microsoft Access 2000 in the bookshops (Microsoft's "Hızlı
Kurs", "Field Guide" series are among them.
Yaşar Tonta
Last updated: March 11,
2002