Week 1: Monday, Jan. 18

• Topics:
  • Data Models
  • What is relational?
• Reading assignment: Elmasri and Navethe, Chapter 2

Monday

• Martin Luther King Birthday - no classes

Tuesday:

• Introduction to the course

Thursday

• History and basic terms

Friday:

• History and basic terms

Week 2: Monday, Jan. 25

• Topics:
  • Data Models
  • What is relational?
• Reading assignment: Elmasri and Navethe, Chapter 2

Monday

• An introduction to data models

Tuesday:

• The hierarchical and CODASYL models

Thursday

• The relational model

Friday:

• Why Relational?

Week 3: Monday, Feb. 1

• Topics:
  • Entity-relationship modeling
  • Relational Algebra
  • Introduction to Oracle
• Reading assignment:
  • Elmasri and Navethe, Chapter 3
  • EASYALG handout
  • Sunderraman Chapter 1

Monday

• The Entity-relationship model

Tuesday:

• The Entity-relationship model

Thursday

• Moving from an E-R diagram to a relational schema (EN reference?)

Friday:

• Basic Algebra

Other Notes:

• First hour exam is Friday, Feb. 12 (next week)

Week 4: Monday, Feb. 8

• Topics:
  • Relational Algebra
  • Introduction to Oracle
• Reading assignment:
  • Elmasri and Navethe, Chapter 3
  • EASYALG handout
  • Sunderraman Chapter 1

Monday

• Basic relational algebra

Tuesday:

• Basic relational algebra

Thursday

• Introduction to SQL

Friday:

• First Hour Exam.

Week 5: Monday, Feb. 15

• Topics:
  • Group Project
  • SQL/Oracle
  • tables and indexes
  • Database import/export
• Reading assignment:
  • Elmasri and Navethe, Chapter 3
  • Sunderraman Chapter 2

Monday

• Introduction to the group project
• Introduction to SQL

Tuesday:

• More on SQL

Thursday

• More on SQL (DDL)

Friday:

• Group Work Day

Week 6: Monday, Feb. 22

• Topics:
  • Introduction to Oracle tools
• Reading assignment:
  • Elmasri and Navethe, Chapter 3
  • Sunderraman Chapter 2
  • Oracle help files

Monday

• No class - instructor ill

Tuesday:

• No class - instructor ill

Thursday

• Data Definition Language

Friday:

• Database loader

Week 7: Monday, March 1

• Topics:
  • The report writer
  • Bottom-up design
  • Database import/export
• Reading assignment:
  • Oracle Help Files

Monday

• Discussion of next exercise
• Introduction to Oracle Tools

Tuesday:

• Report Writer

Thursday

• Intro to Bottom-up Design

Friday:

• Group Work Day

Week 8: Monday, Mar. 8

• Topics:
  • Introduction to Oracle tools
  • Data Normalization
• Reading assignment:
  • Elmasri and Navethe, Chapter 12
  • Oracle help files

Monday

• Data Normalization

Tuesday:

• Resolution of Top-down and bottom-up design schemes

Thursday

• Master-detail reports

Friday:

• Group Work Day

• The second hour exam will be Friday, Mar. 26 (the Friday after Spring Break)

Week 9: Monday, March 22

• Topics:
  • The report writer
  • Views and indexes
  • The Data Dictionary
• Reading assignment:
  • Sunderraman
  • Oracle Help Files

Monday

• Discussion of next exercise
• Views, indexes, and the data dictionary

Tuesday:

• Report Writer: Master-detail exericse

Thursday

• Group Work Day

Friday:

• Exam #2
• Preliminary Design Due

Week 10: Monday, Mar. 29

• Topics:
  • Oracle tools
  • PL/SQL
• Reading assignment:
  • Sunderraman
  • Oracle help files

Monday

• Oracle Forms

Tuesday:

• Forms and Triggers: PL/SQL

Thursday

• PL/SQL and some advanced SQL

Friday:

• Group Work Day

Week 11: Monday, April 5

• Topics:
  • Oracle tools
  • PL/SQL
• Reading assignment:
  • Sunderraman
  • Oracle help files

Monday

• SQL*Forms

Tuesday:

• SQL*Forms

Thursday

• Some advanced SQL

Friday:

• Group Work Day

Week 12: Monday, April 12

• Topics:
  • Advanced SQL
  • Relational Algebra
• Reading assignment:
  • Sunderraman
  • Relational Algebra Handout (in [csmt.matthews.algebra.doc]algebra.mem).

Monday

• Advanced SQL: Using NOT EXISTS for universal quantification.
• An introduction to the tuple calculus

Tuesday:

• The full relational algebra

Thursday

• Relational Algebra and an introduction to the relational calculus
  • DIVIDEBY in the relational algebra
  • tuple calculus
  • domain calculus (a Prolog example)

Friday:

• Group Work Day

Week 13: Monday, April 19

• Topics:
  • Menus (and a final look at Oracle Tools)
  • Theory: Calculus and Algebra
• Reading assignment:
  • Sunderraman
  • Oracle Help Files
  • Textbook: Chapter 6, sections (TBA), chapter 8, sections (TBA)

Monday

• Group Work Day

Tuesday:

• Menu demonstration
• User's guide due

Thursday

• Where do we go from here I: Extensions to the relational model

Friday:

• Group Work Day
• Preliminary Design Due

• The Third Hour Exam was scheduled for Tuesday, April 27 (next Tuesday). This has been rescheduled for Thursday, April 29