http://yunus.hacettepe.edu.tr/~tonta/course/fall2006/bby309/bby309dersamac2006.htm
Hacettepe University
Department of Information Management
BBY 309 Database Management Systems (Fall
2006)
Time and place: Thursday 09:30-12:20 (B8 1K 102)
Instructor:
Teaching
Assistant (TA): İrem Soydal (soydal@hacettepe.edu.tr)
Course web site: http://yunus.hacettepe.edu.tr/~tonta/courses/fall2006/bby309/bby309dersamac2006.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 a small database (Cookie)
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 CLASSROOM DOOR IS
CLOSED AND LECTURE STARTS, STUDENTS WILL NOT BE ALLOWED TO GET IN TO THE
CLASSROOM UNTIL THE 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
|
|
Midterm
I (based on Cookie) |
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.
9th Edition. Upper Saddle River, NJ: Prentice Hall,
2004.
The
textbook web site (http://myphlip.pearsoncmg.com/cw/mpbookhome.cfm?vbookid=505)
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
companion web site.
The Bıçaklar Kitabevi may have copies of this book
available to buy (142.20 USD). 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 26, 2006