| Week -Date | Classroom Prep & Assignments | Lab Assignments |
| Week 1 Jan 5 |
Note: Right
click on the links to download documents. Chapter 1 Presentation Intro Chapter 1 Problems 1.4, 1.5, 1.6, 1.7, 1.9 Due 1/14/04 |
|
| Week 2 Jan 12 |
Chapter 2 Presentation
ER Model Homework: Chapter 1 Terms Worksheet Due 1/21/04 Chapter 2 Terms Worksheet Due 1/26/04 |
Introduction to Visio Chapter 2 ERDiagram Lab |
| Week 3 Jan 19 |
|
Chapter 3 ERDiagram Visio Lab |
| Week 4 Jan 26 |
Chapter 3 Presentation
ER Model II Chapter 2 Terms & Ch2 Lab Due |
Chapter 3 Team Lab Assignment |
| Week 5 Feb 2 |
Chapter 3 ER Model BIG JOB FAIR video & presentation by Butch Reinesch, 367-4819, HC223 |
Complete Team Lab (Due Feb 9) Assignment: Chapter 3 Questions 3.1 - 3.4, 3.11, 3.17 (Due Feb 11) |
| Week 6 Feb 9 |
Chapter 4 Presentation
Normalization |
Click to review the questions submitted by your classmates: |
| Week 7 Feb 16 |
Feb
16 |
Worksheet #1 and Worksheet #2 Due Feb 25 Read p. 120-134, 141-144 |
| Week 8 Feb 23 |
Chapter 4 Normalization
- |
If necessary, install
SQLServer 2000
Presentation in installing SQLServer2000 |
| Week 9 Mar 1 |
Chapter 5 DB Design Start Chapter 6 Presentation Intro to SQL |
Earn Extra Credit! Attend advising! Tues March 2 ADVISING in PM Thurs March 4 ADVISING in AM |
| Week 10 Mar 8 |
Chapter 6 Intro to SQL |
Chapter 4,5 Exam |
| |
March 15-20 Spring Break |
 Mar
17St. Patrick's Day |
| Week 11 Mar 22 |
Chapter 6 Intro to SQL(continued) | Continue using SQLServer2000 CH6 Database from Labs I & II. |
| Week 12 Mar 29 |
Chapter 6 Lab
V
Assignment and
CH6LABV.SQL script |
SQL Quiz Wednesday Ch6 Last Lab on Insert, Update, Delete |
| Week 13 Apr 5 |
Friday April 9 - No School |
Chapter 7
Worksheet - Independent Study - Read
chapter 7 & complete worksheet during the reading. Chapter 7 Worksheet due Download AVIA database Complete Challenge#1 Complete CreateViewRidge Lab after downloading the following scripts: CREATE_ViewRidge.sql and POPULATE_ViewRidge.sql . |
| Wk14 Apr 12 |
April 12 - No School on Monday |
Problems 7.21-7.31 in SQL Server Install Oracle Client Thurs. April 15: Student Org Meeting 10AM |
| Wk15 Apr 19 |
Chapter 7 (continued) SQL Apps |
SQL in Oracle (View Ridge) |
| Wk16 Apr 26 |
Chapter 9 Presentation
Multiuser DB |
Chapter 6,7 Exam (SQL)
Monday Apr 26 |
| Wk17 May 3 |
Chapter 10 Presentation
Managing DB with Oracle Connectivity Presentations ( ODBC, XML) |
|
| Wk 18 May 10 |
|
Chapter 9,10, SQL Final Exam |
Back
Updated April 24, 2004
Jan 19 - No School
Monday
Graduation