http://yunus.hacettepe.edu.tr/~tonta/courses/spring2005/dok322/d322dersamac2005.htm/
Hacettepe University
Department of Information Management
DOK 322 Database Management Systems (Spring
2005)
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)
Teaching
Assistants (TAs): Yurdagül Ünal (yurdagul@hacettepe.edu.tr) &
İrem Soydal (soydal@hacettepe.edu.tr)
Course web site: http://yunus.hacettepe.edu.tr/~tonta/courses/spring2005/dok322/d322dersamac2005.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 “relational data model”. We will discuss the principles and problems
of database design, operation, and maintenance for relational data model.
Assignments: There will be a
few assignments in this course: Cookie and DiveShop assignments will help
familiarize you with the database concepts and you will learn to query existing
databases through a DBMS, namely MS Access.
There will be an Entity-Relationaship (E-R) homework to familiarize you
with the diagramming techniques and design tools. The final project will help you design a
simple database from scratch.
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.
Attendance:
You
must attend all the lectures. If you
are unable to participate two consecutive lectures or a total of three lectures
within the semester, you must produce a formal document explaining the cause(s)
of your absence.
Here is the distribution of the
weights of coursework for DOK322:
|
Assignment/exam |
Points |
|
Attendance |
10 |
|
Cookie assignment |
Ungraded |
|
DiveShop assignment |
Ungraded |
|
Midterm I (based on Cookie and DiveShop
assignments) |
15 |
|
E-R diagram |
5 |
|
Midterm II |
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. (www.prenhall.com/kroenke/)
9th Edition. Upper Saddle River,
NJ: Prentice Hall, 2004.
The textbook web site contains a lot of useful information including tests, miscellaneous resources, and the slides
that will be used during lectures. Please take a close look
at the textbook web site.
The Bıçaklar Kitabevi has a few copies of this
book available to buy (50 YTL) and they are planning
to make more
copies available soon. A copy of this book
is also available at Beytepe Library Reserve Collection (QA76.9 D3 K76
2001). I am also prepared to
share my copy (9th 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 2002 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.
Last updated: March 7, 2005