http://yunus.hacettepe.edu.tr/~tonta/courses/spring2006/dok322/d322dersamac2006.htm/
Hacettepe University
Department of Information Management
DOK 322 Database Management Systems (Spring
2006) 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)
Teaching
Assistants (TAs): İrem Soydal (soydal@hacettepe.edu.tr) and Yurdagül
Ünal (yurdagul@hacettepe.edu.tr)
Course web site: http://yunus.hacettepe.edu.tr/~tonta/courses/spring2006/dok322/d322dersamac2006.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: the Cookie assignment will help you familiarize
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 |
Midterm I (based on Cookie assignment) |
15 |
E-R diagram |
10 |
Midterm II |
15 |
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.
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.
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).
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: February 18, 2006