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/24 Course Overview and Introduction to Databases Chapter 1
  1. Logistics Slides
  2. Database Terminology (Chap 1)
---
8/29 The Relational Model Chapter 4
8/31, 9/5 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/7 SQL: Data Definition Chapter 7 1) DDL Slides
2) Subquery Slides
3) Lecture 9/7
  • hw2 (Due Fri. 9/15 at 6am)
  • 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/12 Relational Algebra and Calculus Chapter 5 1) Slides
2) Lecture
---
9/14 Relational Algebra and Calculus Chapter 5 1) Slides
2) Lecture
hw3 (Due Fri. 9/22 at 6am)
9/19, 21 Entity-Relationship Modeling
  1. Chapter 12
  2. Investment Firm Design Case
1) Slides
2) 9/19 Lecture
3) 9/21 Lecture
4) Investment Firm Solution
hw4 (Due Fri. 9/29 at 6am)
9/26, 9/28 Normalization
  1. Chapter 14
  2. Hotel Case Study
1) Slides
2) 9/26 Lecture
3) 9/28 Lecture
hw5 (Due Fri. 10/13 at 6am--no late acceptance)
10/3, 10/10 Physical Database Design
  1. physical design
  2. Chapter 18
  3. B+-tree and Extendible Hashing handouts on Canvas. Go to Modules and then Course Materials.
  4. B+-Tree Visualization
10/3 Lecture
10/10 Lecture
---
10/5 Fall Break None --- ---
10/12 Extendible Hashing and Exam Review Session Extendible Hashing handouts on Canvas. Go to Modules and then Course Materials. Review Notes
Lecture
---
10/17 Midterm Exam None --- ---
10/19 Introduction to Scripting Languages Lecture
10/24 Perl Control Constructs and Introduction to Regular Expressions Lecture ---
10/26 (Engineering Day)--No class but online video Finishing Regular Expressions --- ---
10/31 Perl Functions, Files, and Sorting perl 2 Lecture
11/2 Perl Modules and Object-Oriented Programming perl 2 Lecture ---
11/7 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 Fri. Nov 17 at 6am)
11/9 XHTML forms Creating xhtml forms Lecture ---
11/14 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/16 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 Wed. Nov 29 at 6am)
11/21 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/23 Thanksgiving   --- ---
11/28 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 Wed. 12/6 at 6am--no late submissions accepted)
11/30 Forms, Events, and Regular Expressions
  1. Forms and form validation
  2. Regular Expressions
Lecture ---
12/5 Ajax
  1. w3schools Ajax tutorial
  2. My Ajax notes
Lecture ---