Click Desired Week Number Below to View        View a TYPICAL CLASS WEEK

1

2

3

4

5

6

7

8

9

10

11

12

13

14

Week

Lecture

Lab

Comments

1

Context; Terms; Introduction; Chapter 1:  File Systems and Databases

Level A: 1.4; 1.5                         Level B: 1.2; 1.3

Questions:  1 to 5; 8; 17; 18 Problems: Page 51 # 1 to 6

Tutorial 1:  Sessions 1.1 and 1.2

If you have little or no previous DB training and/or usage, you will need to really understand Tutorials 1 and 2.

2

Chapter 2:  The Relational Database Model

Level A: 2.1; 2.2                         Level B: 2.3                                 Level C: 2.4 to 2.9

Questions: 1 to 4; 6            Problems: Page 94 # 1 to 7

Tutorial 2:  Sessions 2.1 and 2.2

Currently, the most popular DB implementation model - with varying degrees of compliance with the original model.

3

Chapter 3:  Structured Query Language (SQL)

Level A: 3.1; 3.4; 3.6                     Level B: 3.3.2;  3.3.4; 3.3.5; 3.3.7  Level C: 3.2

Questions & Problems:  TBA

Tutorial 3:  Session 3.1

SQL is powerful but unfamiliar to most.  It is NOT a programming language.

4

Chapter 3:  SQL continued

See above for details

Tutorial 3:  Session 3.2

5

Chapter 4:  Entity Relationship (E-R) Modeling

Level A: 4.1 to 4.4.2                   Level C: 4.4.3

Questions: Page 245  # 2 to 21

Tutorial 4:  Session 4.1

If you are a "visual" person, this modeling technique may be just for you.  The rest of us must learn it and apply it as just another tool in our IT toolkit.

6

Chapter 5:  Normalization of Database Tables

Level A: 5.1; 5.2 omit 5.1.5         Level B: 5.4                                  Level C: 5.1.5; 5.3

Questions: Pg 276 # 1 to 9

Problems: Pg 276 # 1 to 5

Tutorial 4:  Session 4.2

7

Chapter 9:  Transaction Management and Concurrency Control

A: 9.1; 9.1.2; 9.3                                B: 9.2                                                  C: 9.1.1; 9.1.3; 9.1.4; 9.4; 9.5; 9.6

Questions: Pg 432 # 1 to 10

Problems: Pg 433 # 8

Tutorial 5:  Session 5.1

8

Midterm Exam

Monday:  Review

Wednesday:  Written exam

Friday:  Lab midterm exam.  You will need to turn in a diskette containing  your completed work.

The LAB midterm will require that you be able to detail an entity; create appropriate table(s), queries, forms and reports. You will need to work quickly to complete all the requirements.

9

Chapter 10:  Distributed Database Management Systems

Details:  TBA

Tutorial 5:  Session 5.2

Lab Project begins.

Requirements for Lab Project will be presented this week.  You may work individually or in groups of no more than four (4) persons.  Project must be approved by instructor PRIOR to commencing work.

10

Chapter 11:  Object-Oriented Databases

Details:  TBA

Tutorial 5:  Session 5.3

The "up and coming" challenger to the relational model.

11

Chapter 12:  Client/Server Systems

Details:  TBA

Tutorial 6:  Session 6.1

12

Chapter 13:  The Data Warehouse

Details:  TBA

Tutorial 6:  Session 6.2

Did you know that smaller implementations of a data warehouse are called "data marts"?

13

Possibile topics:

1.  Using VB6 as a front-end to Access tables

2.  Chapter 14:  Databases and The Internet

VB 6.0 programming together with MS-Access

OR

Examining Allaire's ColdFusion product

14

Review for comprehensive written final exam

Review and/or final efforts with Lab Projects.  NO LAB FINAL EXAM

Lab Projects are due no later than 4:00 pm on Friday of this week.