http://yunus.hacettepe.edu.tr/~tonta/courses/spring2005/dok322/d322takvim2005.htm
Hacettepe University
Department of Information Management
DOK 322 Database Management Systems (Spring
2005)
Time and place: Mondays 09:10-13:00 (B8 1K 102)
Instructor:
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/
Course
Objectives and Reading List
21/02: Introduction to Database
Processing
Introduction to Course;
Basic database concepts; file management vs. database management systems
Read Kroenke, Chapter 1, Kroenke, Chapter 1 Slides
28/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 21, 2005
9:00 am.
7/03: Entity-Relationship
Data Modeling: Tools and Techniques; Case Studies of Database Applications (cont’d)
Read Kroenke, Chapter 2, Kroenke, Chapter 2 Slides
Homework: DiveShop database assignment (Ungraded). To be completed by March
21, 2005 9:00 am.
Lecture Slides: Database Design Process
Lecture Slides: Entity-Relationship Data Modeling: Tools and Techniques
14/03:
Entity-Relationship
Data Modeling: Process and Examples
Read Kroenke, Chapter 3, Kroenke, Chapter 3 Slides
Homework: Cookie
Entity-Relationship (E-R) Diagram. Due in class on March 28, 2005 9:00 am.
21/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 Cookie and Diveshop homeworks and asked to
answer them using Cookie and Diveshop databases. 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.)
28/03: Logical Database
Design; Relational Model and Normalization
Read Kroenke, Chapter 4, Kroenke, Chapter 4 Slides
Cookie E-R diagram assignment due: 09:00 a.m.
04/04: Physical Database Design
Read Kroenke, Chapter 5, Kroenke, Chapter 5 Slides
11/04: Introduction to Structured
Query Language (SQL)
Read Kroenke, Chapter 6, Kroenke, Chapter 6 Slides
Homework: Final
Project: due on May 16, 2005 09:00 a.m.)
18/04: Using SQL in Applications
Read Kroenke, Chapter 7, Kroenke, Chapter 7 Slides
25/04: Database Redesign
Read Kroenke, Chapter 8, Kroenke, Chapter 8 Slides
02/05:
Internet Database Environment
Read Hoffer, Prescott
& McFadden, Chapter 10
09/05: Midterm II
16/05:
Internet Database Environment
(cont’d)
Read TBA
Final project due: 09:00 a.m.
23/05: Data and Database Administration
Read Hoffer, Prescott
& McFadden, Chapter 12
Last updated: April 18, 2005