Dr. Huegler's CISC255 Web Page
Fall 2008
Section 90
MW 2:10 PM
Section 01
T 5:05 PM
Section 90
M 5:05 PM
Section 01
TR 2:10 PM
Syllabus
HERE is a copy of the syllabus.
Texts
Database Systems: Design, Implementation, and Management, 8th Edition
by Peter Rob and Carlos Coronel
Thompson/Course Technology
ISBN: 978-1-4239-0201-0
Exploring Microsoft Office Access 2007 Comprehensive, 1st Edition
by Robert Grauer and Maurie Lockley
Pearson/Prentice Hall
ISBN: 9780131567887
Online Resources
You can access the web content for the Rob book at http://www.course.com/mis/dbs8 and follow the instructions.
You can access the web content for the Grauer book at http://www.prenhall.com/exploring and follow the instructions.
MS Visio
Microsoft Visio is available for free at http://penguin.lhup.edu/msdnaa. It is also available on computers in FOUN200 and the open lab.
Group Projects
HERE is the overview of the class project.
HERE is a sample data model writeup. This is ROBCOR Catering problem (number 8 in chapter 4).
Current Schedule
Here is the current schedule. It may change from time to time, so check back once in a while. The test dates are firm. I will add slides, assigments, etc. in this section.
| Date | Coverage | Assignments | Notes |
| 8/25/2008 | Introduction | Read Rob Chapter 9 | Introcution Slides |
| 8/27/2008 | Rob Chapter 9 | Review Questions 1, 2, 3, 4, 6, 8; Problems 1a, 1f, 2, 3 | Chapter 9 |
| 9/1/2008 | No Class | Labor Day | |
| 9/3/2008 | Rob Chapter 1 |
Review Questions 1 - 13; Problems 1 - 10 |
Chapter 1 |
| 9/8/2008 | Rob Chapter 2Review Questions: 1 - 3, 6 - 8, 12, 14 - 20; Problems: 1, 2, 6, 7, 8, 9, 22, 23 HAND IN Problems: 23, 24 Due by beginning of class 9/15/2008 |
Chapter 2 | |
| 9/10/2008 | Using Visio | ||
| 9/15/2008 | Rob Chapter 3 |
Review Questions: 1 - 4, 6, 8 - 15; Problems: 1 - 6, 8 - 12, 14, 15; HAND IN Problems: 23 - 28 Due by beginning of class 9/22/2008 |
Chapter 3 |
| 9/17/2008 | |||
| 9/22/2008 | Rob Chapter 4 |
Review Questions: 1 - 20; Problems: 1, 3, 5 a)-e), 7; HAND IN Problems: 8 Due by beginning of class 9/29/2008 |
Chapter 4 |
| 9/24/2008 | |||
| 9/29/2008 | Rob Chapter 5 |
Review Questions: 1 - 14; Problems: 1 - 10 (Don't draw relational schemas) Get a Penguin Account HAND IN Problems: 11, 12, 14 (Don't draw relational schemas) Due by beginning of class 10/7/2008 |
Chapter 5 |
| Date | Coverage | Assignments | Notes |
| 10/1/2008 | |||
| 10/7/2008 | Rob Chapter 6 |
Review Questions: 1 - 6, 8 - 11, 13 - 15; Problems: 1, 2 HAND IN Problem: 4 Due by the beginning of class 10/13/2008 |
Monday Schedule, Chapter 6 |
| 10/8/2008 | |||
| 10/13/2008 | Test 1 | ||
| 10/15/2008 | Rob Chapter 7 and 8 | Homework - See the last slide in the presentation | Chapter 7 and 8 Part 1 |
| 10/20/2008 | Rob Chapter 7 and 8 | Homework postponed until 11/3 | Chapter 7 and 8 Part 2, Script File |
| 10/22/2008 | |||
| 10/27/2008 | Finish SQL - use script file from 10/20 |
HAND IN Chapter 7 Problems 16 - 30
E-mail me a script file with all of your SQL in it. HERE is a SQL script file to create the tables and insert the data. Due by beginning of class on 11/3/2007. |
HERE is the homework answers. |
| 10/29/2008 | Open Day - use for projects and SQL homework | Draft project report due by 11:59 PM on 10-31-2008 | |
| Date | Coverage | Assignments | Notes |
| 11/03/2008 | Grauer Chapter 1 |
Read the chapter, do the hands-on exercises and practice exercises HAND IN Do the 3 mini cases at the end of Chapter 1. Print what is required and hand in the hard copies. Due at the beginning of class on 11/5/2008 |
Grauer Chapter 1 Slides |
| 11/5/2008 | Project time - update final reports | ||
| 11/10/2008 | Grauer Chapter 2 |
Read the chapter, do the hands-on exercises and practice exercises HAND IN Do mid-level exercises 1 and 3 at the end of Chapter 2. Print what is required and hand in the hard copies. Due at the beginning of class on 11/12/2008 |
Grauer Chapter 2 Slides, Final project report due by 11:59 PM on 11-10-2008 |
| 11/12/2008 | Grauer Chapter 3 |
Read the chapter, do the hands-on exercises and practice exercises HAND IN Do mini cases 1 and 3. For case 1, print the vacation query datasheet and the customer balance datasheet. Print what is required for mini case 3. Hand in hardcopies. Due at the beginning of class on 11/17/2008 |
Grauer Chapter 3 Slides, Final project report due by 11:59 PM on 11-10-2008 |
| 11/17/2008 | Grauer Chapter 4 |
Read the chapter, do the hands-on exercises and practice exercises HAND IN Do mini cases 1 and 3. Print what is required and hand in hard copies. Due at the beginning fo class on 11/19/2008 |
Grauer Chapter 4 Slides |
| 11/19/2008 | Grauer Chapter 6 |
Read the chapter, do the hands-on exercises and practice exercises HAND IN Do mini case 1. Print your form and hand in hard copies. Due at the beginning of class on 11/24/2008 |
Grauer Chapter 6 Slides |
| 11/24/2008 | |||
| 11/26/2008 | No Class | Thanksgiving | |
| Date | Coverage | Assignments | Notes |
| 12/1/2008 | |||
| 12/3/2008 | |||
| TBD | Test 2 | This is during finals week | |
| Date | Coverage | Assignments | Notes |