redchecks.gif (1881 bytes)

Computer Information Systems 295 - Spring 2004
Database Management and Design
 
Week -Date Classroom Prep & Assignments Lab Assignments
Week 1
Jan 5
Note:  Right click on the links to download documents.  
C
hapter 1 Presentation Intro
Chapter 1 Problems 1.4, 1.5, 1.6, 1.7, 1.9
Due 1/14/04
 
Visit www.prenhall.com/kroenke
Complete the skills inventory form
 
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


Jan 19 - No School Monday
Martin Luther King Day
Jan 20 - No School - Inservice Day

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
Chapter 3 In-Class Review Assignment:
Write three questions with answers that could be used on the exam.  One should be Multiple Choice, one True/False, and one fill-in-blank or short essay.

 

Click to review the questions submitted by your classmates:
Chapter 1,2,3 Exam - Weds Feb 11
 

Week 7
Feb 16
 

Feb 16
President's Day - No School Monday


Chapter 4 Presentation Normalization

Worksheet #1 and
Worksheet #2 Due Feb 25
Read p. 120-134, 141-144
Week 8
Feb 23    

Chapter 4 Normalization -
Chapter 4 Quiz Wed Feb 25

Start Chapter 5 Presentation DB Design

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
SQL Server Labs I and II

Chapter 4,5 Exam
 
 
 

March 15-20 Spring Break

 

Mar 17
St. Patrick's Day
Week 11
Mar 22
Chapter 6 Intro to SQL(continued)

SQL Servers Labs III  Due Monday and  IV Due Weds

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
Chapter 7 Presentation SQL Apps

 

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
Download oraview.sql and vrdata.sql

 

Chapter 6,7 Exam (SQL) Monday Apr 26
 
Wk17
May 3
Chapter 10 Presentation Managing DB with Oracle
Connectivity Presentations ( ODBCXML)
 
Wk 18
May 10


Graduation
Chapter 15 Presentation Enterprise DB

Chapter 9,10, SQL Final Exam

Back
Updated April 24, 2004