http://yunus.hacettepe.edu.tr/~tonta/courses/fall2005/bby309/bby309takvim2005.htm
Hacettepe University
Department of Information Management
BBY 309 Database Management Systems (Fall
2005) Yaşar Tonta
Time and place: Monday
Instructor: Yaşar Tonta (e-mail: tonta@hacettepe.edu.tr; tel: 297 82 04)
Teaching
Assistants (TAs): İrem Soydal (soydal@hacettepe.edu.tr)
& Yurdagül Ünal (yurdagul@hacettepe.edu.tr)
Course web site: http://yunus.hacettepe.edu.tr/~tonta/courses/fall2005/bby309/bby309dersamac2005.htm
Course
Objectives and Reading List
03/10: 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
10/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
17/10: Case Studies
of Database Applications; Introduction to Microsoft Access
2000 (cont’d)
Read Kroenke, Chapter 1 and look through
a MS Access book; Use MS
Access in the Computer Laboratory
24/10: Entity-Relationship
Data Modeling: Tools and Techniques
Read Kroenke, Chapter 2, Kroenke, Chapter 2 Slides (original); (local copy on course
web site; FASTER)
Lecture Slides: Database Design Process
Homework: Cookie databases assignment (Ungraded). To be completed by November 07, 2005 12:30 pm.
31/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 21, 2005 12:30 pm.
07/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.)
14/11: Logical Database
Design; Relational Model and Normalization
Read Kroenke, Chapter 4, Kroenke, Chapter 4 Slides
E-R diagram assignment
due: 12:30 p.m.
21/11: Physical Database Design
Read Kroenke, Chapter 5, Kroenke, Chapter 5 Slides
28/11: 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.)
Presentation: Example database: “University”
Presentation slides for “University” database.
05/12: Using SQL in Applications
Read Kroenke, Chapter 7, Kroenke, Chapter 7 Slides
12/12: Database Redesign
Read Kroenke, Chapter 8, Kroenke, Chapter 8 Slides
19/12: Midterm II
26/12:
Internet Database Environment
Read Hoffer, Prescott
& McFadden, Chapter 10
02/01: Data and
Database Administration
Read Hoffer, Prescott
& McFadden, Chapter 12
Final project due: 12:30 p.m.
Last updated: Nov. 28, 2005