http://yunus.hacettepe.edu.tr/~tonta/courses/spring2003/dok322/d322dersamac2003.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/spring2003/dok322/d322dersamac2003.htm/
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 the 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. One set
of assignments will involve the use of existing databases (Cookie and
Northwind) to answer a set of queries while you will modify the existing Cookie
database to improve it. 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.
Here
is the distribution of the weights of coursework for DOK322:
|
Assignment/exam |
Points |
|
Cookie assignment |
7,5 |
|
Northwind assignment |
7,5 |
|
E-R diagram |
5,0 |
|
Midterm |
20 |
|
Final Project |
20 |
|
Final Exam |
40 |
|
Total |
100 |
Academic or scholastic dishonesty, such as plagiarism, cheating, or
academic fraud, will not be tolerated and will incur the most severe penalties,
including failure for the course. All
individual work is assumed to be done individually and responsibly. If there is any concern about behavior that
may be academically dishonest, please consult the instructor. Students are also encouraged to refer to the
Higher Education Council’s “By-Law of the Student Code of Conduct” (Yükseköğretim Kurumları Öğrenci Disiplin
Yönetmeliği), especially clause 9/m, which states that students
attempting to cheat or plagiarize shall be expelled from school for one or two
academic semesters.
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.
A copy of this book is available
at Beytepe Library Reserve Collection.
I am also prepared to 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:
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)
Atre, S. Data Base:
Structured Techniques for Design, Performance, and Management.
New York: Wiley, 1980.
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: February 25,
2003