---

Schedule for Week 1 (1/20/98)

---

Reading: Date, chapters 1 and 2

---

• Monday: Martin Luther King, Jr. Birthday: No classes
• Wednesday:
  • Introduction to the course.
  • Introduction to Database Systems
• Friday: Introduction to Database Systems

---

Schedule for Week 2 (1/27/98)

---

Reading: Date, chapter 3, EasyAlg handout (on the VAX)

---

• Monday:
  • More on database systems
  • Data Models
• Wednesday:
  • Data Models
  • The Hierarchical Model
  • The Network/CODASYL Model (Introduction)
• Friday:
  • The Network/CODASYL Model (Continued): Connections with COBOL
  • The Relational Model
  • The Relational Algebra (look at dia0:[algebra.doc]easyalg.mem)

Schedule for Week 3 (2/2/98)

---

• Topics : Relational model / introduction to Oracle
• Reading assignment: Date 4, 5, 8, Krohn 1 - 4
• First Algebra (EasyAlg) exercise
• First SQL exercise
• Monday is the last day to drop without record

---

• Monday:
  • EasyAlg.
• Wednesday:
  • Easyalg, continued
  • First algebra exercise
• Friday:
  • Discussion on control scripts
  • An introduction to Oracle
  • An introduction to SQL

---

Schedule for Week 4 (2/9/98)

---

• Topics : Introduction to Oracle, SQL
• Reading assignment: Date 8, Krohn 1 - 4
• First SQL exercise
• Index/View exercise

---

• Monday:
  • Introduction to SQL, cont'd.
  • First SQL exercise
• Wednesday:
  • Create/Drop tables
• Friday:
  • Indexes and Views
  • Introduction to the term project

---

Schedule for Week 5 (2/16/98)

---

• Topics: Tables, indexes, and views. The database loader
• Reading assignment: Date 12
• First hour exam Friday, Feb. 20
• Monday is the last day to drop with an automatic "W".

---

• Monday:
  • Indexes and views, cont'd.
  • Discussion on the project
• Wednesday:
  • The database loader
  • Some Relational Theory
  • Second SQL exercise
• Friday:
  • First Hour Exam

---

Week 6: Monday, Feb. 23

• Topics: Top-down (Entity-Relationship) database design
• Reading assignment: Date 12
• Group meetings should begin
• Design exercise (a major exercise, in several parts).
• Project Proposals Due

---

• Monday:
  • The Database Loader
  • Exam #1 returned and discussed
  • Project proposals due
• Wednesday:
  • Entity-relationship diagrams
  • Design exercise
• Friday:
  • Entity-relationship diagrams, cont'd
  • Moving from an E-R diagram to a relational schema.
  • An introduction to bottom-up design

---

Week 7 Monday, March 2

• Topics: Database design: more on ER design and an introduction to bottom-up design and data normalization. Introduction to database tools
• Reading assignment: Date 9, 10, 12, Krohn 12
• Requirements Document due (Monday).

---

Monday

• Bottom-up design
• Introduction to normalization
• Requirements Document due (changed to Wednesday).

Wednesday:

• Data Normalization

Friday:

• Resolving top-down and bottom-up designs

---

Week 8 Monday, March 9

• Topics:
  • Introduction to database tools
  • SQL*Forms
• Reading assignment: Krohn 7
• The preliminary design document, which was to be due Monday of the week following Spring break, is deferred to that Wednesday.
• Second hour exam is Friday, March 27 (week following Spring Break)

---

Monday

• SQL*Forms

Wednesday:

• SQL*Forms: Master-detail forms

Friday:

• Class cancelled

Week 9 Monday, March 23

• Topics: SQL*Forms, Introduction to SQL*Report
• Reading assignment: Krohn 5, 12
• Preliminary Design Due (Friday - note change).
• Second hour exam is Friday, March 27.

---

Monday

• Review of database tools, master-detail forms.

Wednesday:

• A very quick introduction to triggers and PL/SQL

Friday:

• Second Hour Exam
• Preliminary Design due (Friday).

---

Week 10 Monday, March 30

• Topics:
  • SQL*Report
  • SQL*Menu
  • Embedded SQL
• Reading assignment: Date 8, Krohn 4,5
• Design Document Due Friday

---

Monday

• SQL*Report

Wednesday:

• SQL*Menu

Friday:

• SQL*Menu
• Embedded SQL
• Design Document Due

---

Week 11 Monday, April 6

• Topics: Advanced SQL
• Reading assignment: Date 8, Krohn 4
• Preliminary Design past due
• Detailed Design due Friday

---

Monday

• Advanced SQL.
• Second Hour Exam returned and discussed

Wednesday:

• More on SQL: Relational Algebra Operators and nested queries.

Friday:

• Advanced SQL: EXISTS/ NOT EXISTS,

---

Week 12 Monday, April 13

• Topics:
  • Topics in Theory
  • Advanced SQL
  • Relational Algebra
  • Relational Calculus (perhaps)
• Reading assignment: Date 6 - 8, Krohn 4, handout
• Detailed Design past due
• User's document due next week
• Third hour exam Friday, April 24.

---

Monday

• Advanced SQL: Nulls, Outer join, data dictionary, etc.
• Final SQL exercise

Wednesday:

• Full Relational Algebra

Friday:

• Full Relational Algebra: DIVIDEBY
• Short RelAlg exercise (final exercise of the term)
• Introduction to the relational calculus

---

Week 13 Monday, April 20

• Topics:
  • Relational Calculus
  • Third Hour Exam is Friday, April 24.
  • User's document due Friday, April 24 (note change in due date)
• Reading assignment: Date 6, 7, handouts

---

Monday

• Predicate logic and the tuple calculus

Wednesday:

• Prolog and the relational domain calculus

Friday:

• Exam #3

---