http://yunus.hacettepe.edu.tr/~tonta/courses/spring2004/dok322/d322dersamac2004.htm/
Hacettepe University Department of
Information Management
DOK 322 Database Management Systems (Spring 2004) Yaşar Tonta
Time and place: Monday 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/d322dersamac2004.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.
8th Edition. Upper
Saddle River, NJ: Prentice Hall, 2001.
A copy of this book is available
at Beytepe Library Reserve Collection (QA76.9 D3 K76 2001).
I am also prepared to share my copy (6th ed.) 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.
We will be using
MS Access 2000 as a database management system to complete assignments
and design final projects. You can find several
books on Microsoft Access 2000 in the bookshops and libraries (Microsoft's
"Hızlı
Kurs", "Field Guide" series are among them). For the
web database development component of the course, some chapters of
the following book are relevant: Jim Buyens, Web Veritaban
GeliŸtirme. Ankara: ArkadaŸ Kitabevi, 2000.
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.
Yaşar Tonta
Last
updated: February 16,
2004