http://yunus.hacettepe.edu.tr/~tonta/courses/spring2006/dok322/d322takvim2006.htm
Hacettepe University
Department of Information Management
DOK 322 Database Management Systems (Spring
2006) Yaşar Tonta
Time and place: Mondays 09:10-13:00 (B8 1K 102)
Instructor: Yaşar
Tonta (e-mail: tonta@hacettepe.edu.tr;
tel: 297 82 04)
Teaching
Assistants (TA): İ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/
Course
Objectives and Reading List
20/02: Introduction to Database
Processing
Introduction to Course;
Basic database concepts; file management vs. database management systems
Introduction to the Course (Slides)
Read Kroenke, Chapter 1
27/02: Case Studies
of Database Applications; Introduction to Microsoft Access
2000
Read Kroenke, Chapter 1 and look through a MS Access book; Use MS Access in the Computer Laboratory
Homework: Cookie database assignment (Ungraded). To be completed by March 20, 2006 9:00 am.
Answers for Cookie
Assignment (NOW
AVAILABLE..)
6/03: Entity-Relationship
Data Modeling: Tools and Techniques; Case Studies of Database Applications (cont’d)
Read Kroenke, Chapter 2, Kroenke, Chapter 2 Slides (original); (local copy on course
web site; FASTER)
Lecture Slides I: Database Design Process
Lecture Slides II: Database Design
ÞÞÞ
DOK 322 Database Management Systems Blog is active. Please visit the
blog’s website http://dok322.blogspot.com
and click the “Blog this!” link on the top of the page in order to
register the blog (please remember
to register with your REAL NAMES). Once you register
you can easily post your questions and comments related to the course
and will receive the announcements about assignments and exams, etc.
13/03:
Entity-Relationship
Data Modeling: Process and Examples
Read Kroenke, Chapter 3, Kroenke, Chapter 3 Slides (local copy on course
web site; FASTER)
Homework: Entity-Relationship (E-R) Diagram. Due in class on March 27, 2005 9:00 am.
20/03: Midterm I
Note: This midterm aims
to test your knowledge of MS Access and will
be a practical one. It will take place
in the Department’s Computer Lab. Each student will be given a few questions
similar to the ones contained
in the Cookie homework and asked to answer them
using the Cookie database. Answers will be stored in each student’s designated workspace under Network Neighborhood/bilgi/<your_directory> (More detailed instructions
will be provided during class and before the exam.)
Answers for Midterm
I (Will be available after exam)
27/03: Logical Database
Design; Relational Model
and Normalization
Read Kroenke, Chapter 4, Kroenke, Chapter 4 Slides
E-R diagram assignment
due: 12:30 p.m.
03/04: Physical Database Design
Read Kroenke, Chapter 5, Kroenke, Chapter 5 Slides
10/04: Introduction to Structured Query Language (SQL)
Read Kroenke, Chapter 6, Kroenke, Chapter 6 Slides
Homework: Final
Project: due on May 15, 2006 09:00 a.m.) (NEW!!!)
Presentation: Example database: “University” (To show how to
design a database –from last year)
Presentation slides for “University” database. (To show how to
create tables, data netry screens, reports, etc.)
17/04: Using SQL in Applications
Read Kroenke, Chapter 7, Kroenke, Chapter 7 Slides
24/04: Database Redesign
Read Kroenke, Chapter 8, Kroenke, Chapter 8 Slides
01/05: Midterm II
08/05: Database Redesign (Cont’d)
Read Kroenke, Chapter 8, Kroenke, Chapter 8 Slides
15/05: Data Structures for Database Processing
Read Kroenke, Appendix
A, Kroenke, Appendix A Slides
Final project due: 09:00 a.m.
22/05: Internet
Database Environment; Data
and Database Administration
Read Hoffer, Prescott
& McFadden, Chapter 10,
12
Last updated: May 15, 2006