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 for the database portion of the course refer to chapters in the Connolly and Begg textbook and chapter assignments for the scripting languages portion of the course refer to the Web Programming Zybook.

Date Topics Assigned Readings and Participation Activities Lecture Slides Homework
8/23 Course Overview and Introduction to Databases Chapter 1
  1. Logistics Slides
  2. Database Terminology (Chap 1)
  3. Lecture
---
8/28 The Relational Model Chapter 4
8/30, 9/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/6 SQL: Data Definition Chapter 7 1) DDL Slides
2) Subquery Slides
3) Lecture
  • hw2 (Due Fri. 9/14 at 6am)
  • hw2 supplementary materials-The DreamHome.sql file will create the relations for the Dream Home property man agement firm and can be used with question 8.
9/11 Relational Algebra and Calculus Chapter 5 1) Slides
2) Lecture 		---
9/13 Relational Algebra and Calculus Chapter 5 1) Slides
2) Lecture 		hw3 (Due Fri. 9/21 at 6am)
9/18, 20 Entity-Relationship Modeling
  1. Chapter 12
  2. Investment Firm Design Case
1) Slides
2) 9/18 Lecture
3) 9/20 Lecture
4) Investment Firm Solution 		hw4 (Due Fri. 9/28 at 6am)
9/25, 9/27 Normalization
  1. Chapter 14
  2. Hotel Case Study
  3. Hotel Case Study Answers
1) Slides
2) Lecture 9/25
3) Lecture 9/27 		hw5 (Due Fri. 10/12 at 6am--no late acceptance)
10/2, 10/9 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
Oct. 2 Lecture
Oct. 9 Lecture 		---
10/4 Fall Break None --- ---
10/11 Extendible Hashing and Exam Review Session Extendible Hashing handouts on Canvas. Go to Modules and then Course Materials. Review Notes
Lecture		 ---
10/16 Midterm Exam None --- ---
10/18 Introduction to Web Programming and Scripting Languages
  • Pre-class: All participation activities in Chapter 1 and 2.1-2.5
  • In-class: All challenge activities in 2.4-2.5
Web Programming Project Description
10/23 HTML and Forms Web Programming: Chapters 2 and 3
Lecture
  • Pre-class: All participation activities in Chapter 2.6-2.8 and Chapter 3
  • In-class: All challenge activities in 2.6-2.8 and Chapter 3
hw6--Designing the web interface" (Due Sat. 11/3 at 6am)
10/25 (Engineering Day)--No class but still assigned reading Basic CSS Web Programming: Chapter 4
  • Pre-class: All participation activities in Chapter 4
  • In-class: All challenge activities in Chapter 4
---
10/30 Advanced CSS and PhP Introduction Web Programming: Chapter 5 and Chapter 12.1-12.2
Lecture
  • Pre-class: All participation activities in Chapter 5 and 12.1-12.2
  • In-class: All challenge activities in Chapter 5
---
11/1 PHP Basics
  1. Web Programming 12.3-12.9
  2. Supplementary Reading: PHP Tutorial-Read the PHP Basics section through PHP functions
  3. Supplementary Reading: Introduction to PHP
  4. Supplementary Reading: Getting Started in PHP
  5. Brad's Cliff Notes Version of PHP
  6. Supplementary Reading: Geoff Mazeroff's Cliff Notes Version of PHP
  • Pre-class: All participation activities in Chapter 12.3-12.9
  • In/After class: Canvas quiz--11/1: PHP Basics
  • Lecture
hw7 -- designing the server side in PHP (Due Sat. 11/17)
11/6 Handling Forms and Session Management in PHP
  1. Web Programming: 12.10, 13.4
  2. Supplementary Reading: Handling Forms
  3. Supplementary Reading: PHP Tutorial
    • Read the PHP Basics section from PHP Forms to the end
    • PHP Cookies
    • PHP Sessions
  • Pre-class: All participation activities in Chapter 12.10, 13.4
  • In/After class: Canvas quiz--11/6: PHP Form Handling
  • Lecture
---
11/8 PHP interface to mySQL and Regular Expressions
  1. Web Programming: 13.1, 13.6-13.8
  2. Supplementary Reading: PHP SQL-Read the PHP MySQL Database section
  3. Supplementary Reading: my PHP SQL notes
  • Pre-class: All participation activities in Chapter 13.1, 13.6-13.8
  • In/After class: Canvas quiz--11/8: PHP SQL and Regular Expressions
  • Lecture
---
11/13 Introduction to JavaScript Web Programming: Ch. 6--Basic Javascript and Ch. 8.1-8.2 (reg. exp and classes)
  • Pre-class: All participation activities in Ch. 6 and Ch. 8.1-8.2
  • After-class: All challenge activities in Ch. 6 and Ch. 8.1-8.2
  • Lecture
---
11/15 Javascript in the Browser--HTML DOM, Javascript DOM, Forms, Events, and AJAX
  1. Web Programming: Ch. 7.1-7.6
  2. Supplementary Reading: Javascript DOM
  3. Supplementary Reading: Javascript Forms and Events
  • Pre-class: All participation activities in Ch. 7.1-7.6
  • After-class: All challenge activities in Ch. 7.1-7.6
  • Lecture
hw8--Designing the client side in javascript
Problem 1: Due Thurs 11/22 at 6am--no late submissions accepted
Problem 2: Due Wed. 12/5 at 6am--no late submissions accepted
11/20 Class Canceled No topics/no assignments/no lecture --- ---
11/22 Thanksgiving   --- ---
11/27 JQuery Web Programming: 9.1-9.6
  • Pre-class: All participation activities in 9.1-9.
  • After-class: All challenge activities in 9.1-9.6
---
11/29, 12/4 Node.js and Express
  1. Web Programming: 11.1-11.8
  2. Supplementary Reading (highly recommended because the book is a bit terse): w3schools.com--go to node.js
  • Pre-class: All participation activities in
    • 11/29: 11.1-11.4
    • 12/4: 11.5-11.8
Lecture 11/29
12/4 in-class tutorial