| Harris Office Hours | ISAT/CS 217 | M/W 9-10 and 2-3 Thursday 2-3 |
| Harris Weekly Schedule: | Harris Schedule |
|---|
| Week | Tuesday prep | Tuesday lecture | Thursday prep | Thursday lecture | Major Project deliverable |
| Jan 11 | What is a database and why do we care? Features of
databases in "real life". Course logistics |
Ullman - Chapter 1 | Intro to Computer Databases - concepts and structures | Thursday Jan 14 Decide which project we will do |
|
| Jan 18 | A brief history of computing databases | Chapter 2.1 Chapter 4.1 (See BB assignments for homework) |
Why model? Exercise Begin ER model |
||
| Jan 25 | NOTE: Correction to
reading. Chapter 4.1 - 4.4 (See BB assignments for homework to support the reading) |
ER Modeling continued | Introduction to the project Meet our customer, Harrisonburg/Rockingham Historical Society Begin to develop requirements specification |
Thursday Jan 28 Project Launch |
|
| Feb 1 | Chapter 4.7 (See BB assignments for homework to support the reading) |
UML Diagramming Intro to the Relational Model |
Chapter 2.2 - 2.7 (See BB assignments for homework to support the reading) |
Relational algebra | Thursday Feb 4 Team - Draft Requirements Document |
| Feb 8 | Chapters 4.5, 4.6, 4.8 (See BB assignments for homework to support the reading) |
Relational Model continued Review for Exam 1 |
Study - All reading an lectures | Introduction to Normalization |
Thursday Feb 11 Individual - Critique Requirements Document |
| Feb 15 | No class - Assessment Day | Chapter 3 (See BB assignments for homework to support the reading) | Exam 1 | Tuesday Feb 16 - Critique requirements document | |
| Feb 22 | Chapter 3 - See BB for homework to support reading | Return exam 1 Normalization - Notes |
Chapter 6, Also Schaum's | Go over exam Finish normalization Introduction to SQL |
Thursday Feb 25 Final Requirements Document postponed until Mar 4 |
| Mar 1 | Introduction to
MySQL Meet in ISAT/CS 250 |
Chapter 7,8 | More MySQL Meet in ISAT/CS 250 |
Thursday March 4 Group - Design document (ERD/UML) Tuesday Mar 16 Individual - Critique FINAL |
|
| Mar 15 | Chapter 7,8 | Meet in HHS 2208 More SQL |
And still more MySQL |
Tuesday Mar 16 Individual - Critique design Thursday Mar 18 Group - Interface design |
|
| Mar 22 | Meet in ISAT/CS 250 Connecting to the database; Intro to php and html |
More SQL/Followup from lab | Tuesday Mar 23 - Individual critique interface
design/ |
||
| Mar 29 | Wrap up SQL | Exam 2 | Thursday April 1 Final User Interface design / prototype Group - Progress Report - written |
||
| Apr 5 | Go over exam |
Each group should describe their database design and their user interface. See format for report. | Group project reports No more than 10 minutes each. |
||
| Apr 12 | Chapter 10.1 | Database
security |
Project work day-no class. | Thursday April 15 Group - Demos |
|
| Apr 19 | See BB for Assignment | Transactions
and concurrency |
See BB for Assignment | Alternate data models | |
| Apr 26 | Project presentations - 3 Review for exam |
Project presentations - 3 |
April 29 - Demos due Final project deliverables due May 3. | ||
| May 3 | MONDAY MAY 3, Final hardcopy and electronic submissions. Hardcopy due in my office no later than 4:00pm. | 8 - 10am Final Exam |
| Department of Computer Science | Nancy Harris Home Page | Current Classes Link |