| 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 | Intro to CS 474 | Ullman - Chapter 1 | What
is a database? Examples: L01-WhatIsADatabase-ppt.pdf L01-WhatIsADatabase.pptx |
||
| Jan 18 | What
is data? Examples: L02-WhatIsData-Presentation.pdf L02-WhatIsData-Presentation.pptx |
Database
History Examples: L03-DatabaseHistory-Presentation.pdf |
|||
| Jan 25 | FCDS, Section 2.1, 4.1-4.5 | The
Entity/Relationship Model (E/R) Examples: L04-ERModel-Presentation.pdf |
2:00 Section - No Class - Attend 3:30 lecture if possible. 3:30 Section - Lecture by Dr. Douglas Turnbull, Swarthmore College - "Semantic Music Discovery Engines" (nTelos Room) |
||
| Feb 1 | Introduction to Prof N. Harris. Choose teams, choose project. Introduce contract grading. | ERD Homework 1A Introduction to the Relational Model. |
|||
| Feb 8 | Review project materials on BB under the Project tab. | Project kickoff. Dr. Susan Kruck, Editor, Journal of Information Systems Education | FCDS Chapter 2
(2.2-2.7) Chapter 4.5, 4.6 See BB Assignments for specific assignments |
Relational algebra...operations | |
| Feb 15 | No class - Assessment Day | Chapter 5.1, 5.2 See BB assignment for specific homework problems |
Finish relational algebra |
Thursday Feb 18 Team - Requirements Document |
|
| Feb 22 | Review Chapter 1, 2, 4, beginning of 5. | Exam 1 | Chapter 3 | Introduction to Normalization, Functional dependency | Tuesday Feb 23 Individual - Critique Requirements Document Thursday Feb 25 Group - ERD or UML diagram |
| Mar 1 | Chapter 3 | Normalization continued. Introduction to SQL |
Chapter 6 Schaum's |
Introduction to MySQL - In Rm 250 See Blackboard for notes. |
|
| Mar 8 | Spring break, NO CLASS Enjoy the week off. | ||||
| Mar 15 | DDL in MySQL - In Rm 250 See Blackboard for notes |
Recap lab work, other SQL clauses |
Tuesday Mar 16 Individual - Critique ERD Thursday Mar 18 Group - User interface design |
||
| Mar 22 | Chapter 9.7 | Connecting to a php front end - in Rm 250 See Blackboard for notes. |
Chap 7,8 | More SQL |
Tuesday Mar 23 Individual - Critique user interface designThursday Mar 25 |
| Mar 29 | Finish SQL - review for exam | Exam materials are available in the resources tab in Blackboard. | Exam 2 | Thursday April 1 Group - Progress Report Final User Interface design / prototype |
|
| Apr 5 | Mini project due Monday night. | Review 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 | 10.1 | Database
security |
Time to work on project. Project report due in Blackboard. | ||
| Apr 19 | Transactions and Recovery: Concurrency | Alternate data models | |||
| Apr 26 | Project presentations - 5 Mandatory attendance |
Project presentations - 4 Mandatory attendance Review for exam |
Thursday April 29 Final project due and presentations |
||
| May 3 | MONDAY MAY 3, Final hardcopy and electronic submissions. Hardcopy due in my office no later than 4:00pm. | 1 - 3 pm Final Exam alternate time - See me - 8-10am. |
|||
| Department of Computer Science | Nancy Harris Home Page | Current Classes Link |