http://yunus.hacettepe.edu.tr/~tonta/course/fall2005/bby309/bby309dersamac2005.htm
Hacettepe University
Department of Information Management
BBY 309 Database Management Systems (Fall
2005) Yaşar Tonta
Time and place: Monday 12:40-15:30 (Amfi 1)
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/fall2005/bby309/bby309dersamac2005.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 both theoretical and practical.
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.
In the practical portion of the course you will learn how to use a
relational DBMS (MS Access), use MS Access to query small databases (Cookie and
Diveshop databases) to answer some questions, get familiar with the
Entity-Relationaship (E-R) diagramming techniques and tools, and design a
database yourselves using MS Access as a final project.
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-Relationship (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 considerable amount of time using MS Access (in the
Department’s Microcomputer Lab or elsewhere).
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 shall attend all the lectures.
You shall come to the class on time. Once
the lecture starts, students will not be allowed to get in to the classroom
until we break. 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 BBY309:
Assignment/exam |
Points |
Attendance |
10 |
Cookie assignment |
Ungraded |
DiveShop assignment |
Ungraded |
Midterm I (based on Cookie and DiveShop
assignments) |
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.
The Bıçaklar Kitabevi may have copies
of this book available to buy. 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 as a database management system to complete assignments
and design final projects. You can find several books
on Microsoft Access 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.
Hoffer, J.A., Prescott, M.B.
& McFadden, F.R. Modern Data Base
Management. (7th ed.)
Prentice-Hall, 2005.
Last updated: September 3, 2005