http://yunus.hacettepe.edu.tr/~tonta/courses/fall2006/bby309/bby309takvim2006.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: Yaşar
Tonta (e-mail: tonta@hacettepe.edu.tr;
tel: 297 82 04)
Teaching
Assistant (TA): İrem Soydal (soydal@hacettepe.edu.tr)
Course web site: http://yunus.hacettepe.edu.tr/~tonta/courses/fall2006/bby309/bby309dersamac2006.htm
Course
Objectives and Reading List
25/09: 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
05/10: 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
databases assignment (Ungraded). To be
completed by November 2, 2006 09:30 am.
12/10:
Entity-Relationship
Data Modeling: Tools and Techniques
Read
Kroenke, Chapter 2, Kroenke,
Chapter 2 Slides (original); (local
copy on course web site; FASTER) Kroenke, Chapter 2 slides in Turkish
Lecture
Slides: Database Design Process
19/10:
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 November 23, 2006 09:30 am.
26/10:
Logical Database
Design; Relational Model and Normalization
Read Kroenke, Chapter 4, Kroenke,
Chapter 4 Slides
02/11: 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.)
09/11: Logical Database Design;
Relational Model and Normalization
Read
Kroenke, Chapter 4, Kroenke,
Chapter 4 Slides
16/11:
Physical Database Design
Read
Kroenke, Chapter 5, Kroenke,
Chapter 5 Slides
23/11: Introduction
to Structured Query Language (SQL)
Read
Kroenke, Chapter 6, Kroenke,
Chapter 6 Slides
E-R diagram assignment due: 09:30 a.m.
30/11: Using
SQL in Applications
Read Kroenke, Chapter 7, Kroenke,
Chapter 7 Slides
Homework: Final
Project: due on December 25, 2006 09:30 a.m.)
07/12: Database Redesign
Read Kroenke, Chapter 8, Kroenke,
Chapter 8 Slides
14/12: Midterm II
21/12: Internet
Database Environment
Read
Hoffer, Prescott & McFadden, Chapter 10
28/12: Data
and Database
Administration
Read Hoffer, Prescott & McFadden, Chapter 12
Kroenke, Chapter 9, Kroenke, Chapter 9 Slides
Final project due:
09:30 am.
Last updated:13 November, 2006