COMP220: Database Design II (W'05)
Class Notes

Lecture notes, handouts, and readings for upcoming classes will be posted here. Lecture notes are usually posted two or three days after class.

Week 15

• Handout: Term Review Notes

Week 14

• Exercise: MVC Organization

Week 13

• Lecture Notes: Web Security

Week 12

• Handout: Model-View-Controller Application Design
• Exercise: CRUD Forms

Week 10

• Handout: Transactions
• Readings: Text Chapter 8 pp270-284 (Issues in Writing Data to Databases).

Week 9

• Lecture Notes: Stateless Programming and Session Management
• Handout: Session Management in PHP
• Exercise: Validation
• Readings: Text Chapter 10 (Sessions).

Week 8

• Lecture Notes: Validation
• Exercise: Three-Tier Organization
• Readings: Text Chapter 9 (Validation with PHP and JavaScript). Just skim the section called "JavaScript and Client-Side Validation."

Week 7

• Lecture Notes: Multi-Tier Application Design
• Exercise: Searching
• Readings: Re-read Text Chapter 1 (Database Applications and the Web); Three-Tier Software Architectures; Using PHP to Develop Three-Tier Architecture Applications (just up to the "How it Works" section)

Week 6

• Readings: Text Chapter 8 (Writing to Web Databases). Try to ignore the sections that mention the PEAR library (Chapter 7) as we won't be using it.

Week 5

• Lecture Notes: Data Transfer through HTTP GET and POST
• Handout: Web Application Page Structure
• Exercise: Summary and Detail Views
• Readings: Reread Text Chapter 6 (Querying Web Databases)

Week 4

• Handout: Screen Flowcharts and Redirection
• Exercise: Querying MySQL from PHP
• Exercise Solution: Querying MySQL from PHP
• Readings: Text Chapter 6 (Querying Web Databases)

Week 3

• Handout: Bridging Web Applications and Databases
• Handout: MySQL Peculiarities
• Instructions: Installing the WAMP Environment
• Readings: Text Chapter 5 (SQL and MySQL) and Appendix E (Modelling and Designing Relational Databases), most of this is just review of what we covered in COMP210 but with a MySQL slant;
  You may also find this PHP/MySQL Tutorial or this other PHP/MySQL Tutorial instructive.

Week 2

• Readings: Text Chapters 2 (The PHP Scripting Language) and 3 (Arrays, Strings, and Advanced Data Manipulation in PHP) but skip the section on Regular Expressions;
  You may also find this PHP Tutorial instructive.

Week 1

• Lecture Notes: CGI and Server-Side Scripting
• Handout: Dealing with the Project Webserver
• Readings: Text Chapter 1 (Database Applications and the Web), Appendix D (Web Protocols);
  if you're new to CGI, you may also want to look at How CGI Scripting Works and An Instantaneous Introduction to CGI Scripts and HTML Forms