---

Week 1: Monday, Jan 17

• Topics:
  • Introduction
• Reading assignment:
  • Date chapters 1, 2

Monday

• Martin Luther King Day:  No classes

Tuesday:

• Introduction to the course

Thursday

• Some history and terms

Friday:

An introduction to database models

• Topics:
  • Survey of data models
• Reading:
  • Date, Chapters 1, 2
  • EASYALG handout

Monday

• Record-oriented data models
  • Hierarchical
  • Network/CODASYL

Tuesday:

• The relational model

Thursday:

• More on the relational model and an introduction to the relational algebra.

Friday:

• The relational algebra (con'td)

• Topics:
  • Introduction to Oracle and SQL
• Reading assignment:
  • Date Chapters 3,4; Sunderraman Chapters 1,2;

Monday

• Introduction to Oracle and SQL

Tuesday:

• Further introduction to SQL: creating tables

Thursday

• Indexes, views, and the Oracle data dictionary

Friday:

Indexes, views, and the Oracle data dictionary

• Topics:
  • Introduction to Oracle and SQL
• Reading assignment:
  • Date Chapters 3,4; Sunderraman Chapters 1,2;
  • Report writer tutorial

Monday

• More advanced SQL

Tuesday:

• More advanced SQL

Thursday:

• The report writer

Friday:

• The report writer

 Coming attractions:

 The first hour exam will be next week

• Topics:
  • Introduction to the group project
  • Top-down design
• Reading assignment:
  • Date Chapter 13

Monday

• Introduction to design
• The entity-relationship model

Tuesday:

• Designing using the entity-relationship model

Thursday:

• Designing using the entity-relationship model
• The database loader (did not get to this yet)

Friday:

• First Hour Exam

• Topics:
  • Introduction to the group project
  • Bottom-up design and normalization
• Reading assignment:
  • Date Chapters 13, 10, 11

Monday

• Introduction to the group project

Tuesday:

• Bottom up (forms based) design
• The problem with bottom-up design

Thursday:

• Functional dependencies
• The database loader (I hope)

Friday:

First Normal Form through Third Normal Form

• Topics:
  • Database Design
• Reading assignment:
  • Date Chapters13, 10, 11

Monday

• No class (instructor ill)

Tuesday:

• Data normalization (1NF, 2NF, 3NF, BCNF)

Thursday:

• Extracting a relational schema from a form

Friday:

• No class (conference)

Week 8: Monday, March 6

• Topics:
  • Bottom-up design and normalization
• Reading assignment:
  • Date Chapters 13, 10, 11

Monday

• Bottom-up design

Tuesday:

• Resolving top-down and bottom-up designs

Thursday:

• Introduction to SQL*Forms

Friday:

• SQL*Forms and PL/SQL

Week 9: Monday, March 13:  Spring Break

Week 10:  Monday, March 20:

• Topics:
  • PL/SQL
  • Oracle JDBC
• Reading assignment:
  • Sunderraman, chapters 4, 5

Monday

• PL/SQL in triggers

Tuesday:

• More PL/SQL

Thursday:

• Introduction to the Oracle JDBC

Friday:

• JDBC

Week 11:  Monday, March 27:

• Topics:
  • JDBC
• Reading assignment:
  •  

Monday

Tuesday:

Thursday:

Friday:

• What is relational? (handout to come)

Week 12:  Monday, April 3:

• Topics:
  • Theory
  • Relational Algebra
• Reading assignment:
  • Handout

Monday

• Relational Algebra I

Tuesday:

• Relational Algebra II:  Divideby

Thursday:

• Group Work Day

Friday:

• SQL*Menus