September 1
Introduction, getting to know each other,
organization of the course.
September 6
*** Term project statement due ***
[Readings: Appendix]
File and data structures for database processing
(review).
September 8
[Readings: Chapter 1]
Background, history of database management.
September 13
[Readings: Chapter 2]
Functions of a database management system.
September 15
*** Term project design due ***
[Readings: Chapter 3, pages 83 through 105]
Introduction to the relational model, SQL.
September 20
[Readings: Chapter 3, pages 106 through 113]
The relational algebra.
September 22
*** Homework 1 (SQL) due ***
[Readings: Chapter 3, pages 113 through 126]
Query by example.
September 27
[Readings: Chapter 4, pages 127 through 154]
Relational databases: nulls, views, security,
indexes, changing the database structure,
system catalog, integrity.
September 29
*** Homework 2 (QBE & relational algebra) due ***
[Readings: Chapter 4, pages 154 through 174]
Embedded SQL.
October 4
[Readings: Chapter 5, pages 175 through 193]
Microcomputer database management: creating
and populating a database, creating reports and labels.
October 6
[Readings: Chapter 5, pages 193 through 215]
Microcomputer database management: using SQL, updating
database, views, custom forms, generating applications,
programming, the functions of a DBMS.
October 11
*** Homework 3 (embedded SQL) due ***
[Readings: Chapter 6, pages 217 through 235]
Functional dependence, keys, normalization:
first, second, and third normal forms.
October 13
[Readings: Chapter 6, pages 235 through 244]
Normalization: fourth and higher normal forms.
October 18 Normalization: exercises.
October 20
*** Homework 4 (normalization) due ***
Midterm review.
October 25 *** MIDTERM EXAM ***
October 27
[Readings: Chapter 7, pages 245 through 267]
Introduction to database design: design goals, user views,
design methodology.
November 1
[Readings: Chapter 7, pages 268 through 292]
Introduction to database design: examples, documentation.
November 3
*** Homework 5 (Paradox, Part 1) due ***
[Readings: Chapter 8, pages 293 through 311]
Advanced topics: user views, representing views as relations.
November 8
[Readings: Chapter 8, pages 312 through 364]
Advanced topics: the entity-relationship model,
general design comments, comprehensive design example.
November 10
*** Homework 6 (database design) due ***
[Readings: Chapter 9, pages 365 through 400]
The CODASYL model: basic concepts, data definition,
data manipulation.
November 15
[Readings: Chapter 9, pages 400 through 430]
The CODASYL model: examples, IDMS and the functions of a DBMS.
November 17
[Readings: Chapter 10 , pages 431 through 456]
Physical database design: mapping to relational model,
mapping to CODASYL model, tuning for performance.
November 22
*** Homework 7 (CODASYL model) due ***
[Readings: Chapter 10 , pages 456 through 486]
Physical database design: analyzing space and processing
requirements, example.
(Thanksgiving recess)
November 29
[Readings: Chapter 11, pages 487 through 509]
Fourth-generation environment: overview, the data dictionary.
December 1
*** term project due ***
[Readings: Chapter 11, pages 509 through 536]
Fourth-generation environment: components, languages
and prototyping, emerging software tools.
December 6 *** Homework 8 (Paradox, Part 2) due ***
Discussion of the term project, project presentations.
December 8
Review of the course.
December 12
*** FINAL EXAM *** (409 SLIS Building, 12pm-1:50pm)
INFSCI 1022 main page
Marek Druzdzel's teaching page
Marek Druzdzel's home page