Class Schedule for LIS 558

Database Management Systems and Programming

Location: Middlesex College 15a, Thursdays 1:30 - 4:20 p.m.

Textbook: Kroenke, D. M. (1999). Database Processing: Fundamentals, Design & Implementation. Upper Saddle River, N.J.: Prentice Hall. (2 copies on reserve at the FIMS library)

Class #

Date (2000)

Lecture topic

Readings, Homework

1

Jan 13

Introduction to LIS 558
Introduction to Databases

Chapters 1, 2

2

Jan 20

The Entity-Relationship Model I

Chapter 3,
ER Exercises I

3

Jan 27

The Entity-Relationship Model II

Chapter 3,
ER Exercises II

4

Feb 3

Transformation of Entity-Relationship Models

Chapter 6, Transformation Exercises

5

Feb 10

The Relational Model and Normalization

Chapter 5, Normalization Exercises

6

Feb 17

Foundations of Relational Implementation

Chapter 8

 

Feb 24

---------------------------------- reading week ------------------------------

7

Mar 2

Structured Query Language

Chapter 9,
SQL Exercises

8

Mar 9

Database Application Design

Chapter 10, Readings

9

Mar 16

Introduction to Macro programming

Novalis, Chapters 5,7*

10

Mar 23

Managing Multi-user Databases - Lab demo

Chapter 12

11

Mar 30

Text Retrieval Systems

 

12

Apr 6

Student Project Presentations

 

13

Apr 13

Student Project Presentations

 

 

* Novalis, S. (1997). Access 97 Macro & VBA Handbook. San Francisco: Sybex. (on Reserve at the FIMS library; Chapters 1-9 are worth reading)

LIS 558