Schedule & Notes

Week Title Exercises Slides Reading
Introduction
Database Overview
ppsx
Ch. 1
Database Design
Relational Databases
ppsx
ppsx

Ch. 3
Martin Luther King/Idaho Human Rights
Relational Databases (concluded)
ppsx
Ch. 3
Entity-Relationship Model ppsx Ch. 5
Entity-Relationship Model (concluded)
ERD Example
E-R exercise (answer)  
Project Introduction
Entity-Relationship Model II
Independent Exercises
Normalization Ch. 5
Normalization (concluded) Normalization examples (exercise) (answer)  
Relational Algebra
SQL
Ch. 4
Presidents' Day
SQL (concluded) (ZDNet SQL Reference – Part I)  Word version Ch. 6
MySQL Server Installation
Command Line Interface
MySQL Scripting
MySQL Workbench
Exercise – MySQL (creation/manipulation) Ch. 3
Advanced SQL  
Advanced SQL (concluded)
 
Relational Algebra in SQL
MySQL Reference
Review
Sample Databases
Exercise – SQL Queries
(ZDNet SQL Reference – Part II)  Word version  
Exam 1
Preprogrammed SQL
PHP Introduction
PHP Installation
Ch. 7
PHP Basics
PHP Control Structure
PHP Functions
PHP Arrays
PHP and MySQL
PHP Includes
PHP and MySQL Database Access
PHP Form Handling
Spring Break  
Spring Break
Transactions  
Stored Programs
Exercise – Stored Programs
Exercise – Stored Programs
 
Triggers
Exercise – Triggers
Ch. 9
Concurrency Control
Concurrency Control (concluded)
Views
Exercise – Views
SQL Injection Attacks
Review
 
Exam 2  
Distributed Database Systems Ch. 12
Distributed Database Systems (concluded) Ch. 12
Wed, 5/8 Final Exam: 10:00 am - 12:00 pm