---

Week 1: Monday, Jan 15

• Topics:
  • Introduction
• Reading assignment:
  • Date chapters 1, 2
  • EASYALG Handout (Friday)

Monday

• Martin Luther King Day:  No classes

Tuesday:

• Introduction to the course

Thursday

• Some history and terms
• An introduction to database models

Friday:

• Database models, cont'd

• Topics:
  • Relational Algebra I
  • Introduction to Oracle
  • Introduction to SQL
• Reading:
  • Date, Chapters 3, 4
  • Sunderraman, Chapters 1, 2
  • EASYALG handout

Monday

• Database Models, cont'd
• Relational Algebra I:  EasyAlg

Tuesday:

• Relational Algebra I, part II
• Introduction to SQL

Thursday:

• Introduction to SQL
• Introduction to Oracle

Friday:

• SQL

Week 3: Monday, Jan. 29

• Topics:
  • Introduction to Oracle
  • Introduction to SQL
• Reading:
  • Date, Chapters 4, 13

Monday

• Entity-relationship diagrams

Tuesday:

• Moving from E-R diagrams to a relational schema

Thursday:

• A design exercise in E-R diagrams

Friday:

• Continued discussion on ER->Rel Schema design

Week 4: Monday, Feb. 5

• Topics:
  • Introduction to Oracle Tools
• Reading:
  • Oracle Report Writer Tutorial
  • Oracle Forms Designer Tutorial

Monday

• Introduction to the SQL DDL
  • Create Table
  • Indexes (how/when to use/specify)

Tuesday:

• SQL DDL 
• Update/Delete/Insert

Thursday:

• Oracle Tools
• Report Writer

Friday:

• Report Writer

• Topics:
  • Introduction to Oracle Tools
  • Introduction to the group project
• Reading:
  • Oracle Report Writer Tutorial
  • Oracle Forms Designer Tutorial

Monday

• Introduction to the SQL DDL
  • Create Table
  • Indexes (how/when to use/specify)
• The database loader

Tuesday:

• SQL DDL 
• Database Loader
• Update/Delete/Insert

Thursday:

• Report Writer II

Friday:

• Hour Exam # 1

Week 6: Monday, Feb. 19

• Topics:
  • Introduction to Oracle Tools
  • Advanced SQL
  • PL/SQL
• Reading:
  • SQL03.PPT
  • Oracle Forms Designer Tutorial
  • Date, Chapters 4, 5, 9
  • Sunderraman Chapters 3, 4

Monday

• Some more SQL

Tuesday:

• EXISTS/FORALL

Thursday:

• PL/SQL

Friday:

• PL/SQL
• Introduction to forms

Week 7: Monday, Feb. 26

• Topics:
  • Introduction to Oracle Tools: 
    • Forms
    • Menu generator
• Reading:
  • Oracle Forms Designer Tutorial
  • Date, Chapters 4, 5, 9
  • Sunderraman Chapters 3, 4

Monday

• SQL*Forms

Tuesday:

• Outer join
• The Oracle data dictionary

Thursday:

• No class - instructor ill

Friday:

• No class - instructor ill

Week 8: Monday, March 5

• Topics:
  • Introduction to Oracle Tools
• Reading:
  • Oracle Forms Designer Tutorial
  • Oracle Menu Documentation
  • Date 5, 10, 11

Monday

• Bottom-up design
• Date Normalization
• The Requirements Document will be due Friday (Note change in schedule)

Tuesday:

• Data Normalization

Thursday:

• SQL*Forms

Friday:

• Resolving top-down and bottom-up designs
• Requirements Document Due

---

Other Notes

•  Please note that the next hour exam will be given the week following Spring Break (which happens next week).
• Please also note that we are approximately one week behind the schedule given out at the start of the term. We have plenty of time to catch up, but some future topics may be dropped.
• Friday, March 9 is Mid-term (not an exam date for us)

Week 10: Monday, March 19

• Topics:
  • Resolving top-down and bottom-up design
• Reading:
  • Date, Chapters 13

Monday

• Group Work Day

Tuesday:

• Homework

Thursday:

• Review for Exam

Friday:

• Exam #2

Topics

Monday

• Group Work Day

Tuesday:

• More on forms
• SQL Menu

Thursday:

• SQL Menu

Friday:

• Discussion of documents

Topics

Monday

• Group Work Day

Tuesday:

• Discussion of exam

Thursday:

• Another approach to menus
• Outline of the theory discussion (coming up)

Friday:

• Why are relational database management systems relational?

• Topics:
  • Theory
• Reading:
  • Handout
  • Date Chapters 6, 7

Monday

• Group Work Day

Tuesday:

• The Full relational algebra

Thursday:

• Relational Algebra

Friday:

• Relational Calculus

Week 14: Monday, April 16

• Topics:
  • Theory
  • OODBMS
• Reading:
  • Theory.ppt
  •  

Monday

• Group Work Day

Tuesday:

• Relational Calculus

Thursday:

• Relational Calculus
• Discussion on homework
• Design document due (note revised date)

Friday:

• Review

Other Notes:

• The third hour exam will be next Tuesday