Lecture Notes

Important: The dates and the assigned readings are tentative until a few days before the actual class so you should make sure you check this site regularly. Chapter assignments refer to chapters in the Connolly and Begg textbook.

Date Topics Assigned Readings Lecture Slides Homework
8/21 Course Overview and Introduction to Databases Chapter 1 Slides ---
8/26 Introduction to Data Modeling Chapter 2 video ---
8/28 The Relational Model Chapter 4 Slides and Video ---
9/2, 4 SQL: Data Manipulation
  1. Chapter 6 (skim)
  2. w3schools SQL Tutorial. Read all the SQL Basic, play with the SQL demo, and read the following topics in the advanced section:
    • SQL Order By
    • SQL and & or
    • SQL In
    • SQL Between
    • SQL Join
    • SQL Create
  3. My SQL Notes
  4. Getting Started with Your MySql Database
9/9 SQL: Data Definition Chapter 7 1) DDL Slides
2) Subquery Slides
3) Lecture Video		 ---
9/11 Relational Algebra and Calculus Chapter 5 1) Slides
2) 9/11 Lecture
  • hw2 (Due Thurs. 9/18)
  • hw2 supplementary materials-The DreamHome.sql file will create the relations for the Dream Home property management firm and can be used with question 8.
9/16 Relational Algebra and Calculus Chapter 5 Slides and Lecture ---
9/18, 23 Entity-Relationship Modeling
  1. Chapter 12
  2. Investment Firm Design Case
1) Slides
2) Lecture 9/18 3) Lecture 9/23 		hw3 (Due Thurs. 9/25)
9/25, 9/30 Normalization
  1. Chapter 14
  2. Hotel Case Study and Solutions
1) Slides
2) 9/25 Normalization Lecture
3) 9/30 Normalization Case Study Lecture
 hw4 (Due Thurs. 10/2)
10/2, 7 Physical Database Design
  1. physical design
  2. Chapter 18
  3. Appendix F or Lecture 10/7 materials on Btrees and Extendible Hashing on Blackboard
1) 10/2 Lecture
2) 10/7 Lecture 		hw5 (Due Tues. 10/14--last late acceptance is Wed. 10/15 at 11:59pm)
10/9 Introduction to Scripting Languages
  1. Lecture 10/9
  2. Lecture 10/14
10/14 Perl Basics --- ---
10/16 Fall Break None --- ---
10/21 Midterm Exam None --- ---
10/23 (Engineering Day)--No class but online video Regular Expressions --- ---
10/28 Exam Review perl 2 Lecture
10/30 Perl Functions, Files, Sorting, Modules, and Object-Oriented Programming perl 2 Lecture ---
11/4 PHP Basics
  1. PHP Tutorial-Read the PHP Basics section through PHP functions
  2. Introduction to PHP
  3. Getting Started in PHP
  4. Brad's Cliff Notes Version of PHP
  5. Geoff Mazeroff's Cliff Notes Version of PHP
Lecture hw8(Due Thurs. Nov 13)
11/6 XHTML forms Creating xhtml forms Lecture ---
11/11 Handling Forms and Session Management in PHP
  1. PHP Tutorial
    • Read the PHP Basics section from PHP Forms to the end
    • PHP Cookies
    • PHP Sessions
  2. Handling Forms
Lecture ---
11/13 XML and PHP interface to mySQL
  1. PHP SQL-Read the PHP MySQL Database section
  2. my PHP SQL notes
  3. XML Introduction
  4. XML Schemas
  5. PHP XML Parsing
Lecture hw9(Due Thurs. Nov 20)
11/18 Introduction to JavaScript
  1. w3 schools JavaScript notes up to, and including, JS Validation.
  2. my JavaScript notes
  3. Arrays, Functions, and Objects
  4. w3 schools JS Objects. First
Lecture ---
11/20 HTML DOM and Javascript DOM API
  1. w3 schools JS HTML DOM. First go to "Learn JavaScript" and then to "JS HTML DOM".
  2. Javascript DOM
Lecture hw10 (Due Tues. 12/2)
11/25 Forms, Events, and Regular Expressions
  1. Forms and form validation
  2. Regular Expressions
Lecture ---
11/27 Thanksgiving   --- ---
12/2 Ajax
  1. w3schools Ajax tutorial
  2. My Ajax notes
Lecture ---