| Date | Topic | Reading/Activity | Assignment | |
|---|---|---|---|---|
| Tuesday, 1/23 |
Course Orientation
Introduction Study Sheet 1.1 |
A: Ch 1 | ||
| Thursday, 1/25 |
Database Environment
Study Sheet 1.2 |
A: Ch 2 | ||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 1/30 |
Relational Model
Study Sheet 2.1 |
A: Ch 3 | HW1 - A: Problems 3.8-3.10; 10 points; due Thursday 2/1. | |
| Thursday, 2/1 |
Relational Algebra
Study Sheet 2.2 |
A: Ch 4 up to page 102 | HW2 - A: Problems 4.8 and 4.12 (relational algebra only), due Thursday 2/8. | |
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 2/6 |
Simple Queries
Study Sheet 3.1 |
A: Ch 5, 112-134
B: Ch 8, 11 |
Project 1 Due Tuesday February, 20 | |
| Thursday, 2/8 |
Joins and Nested Queries
Study Sheet 3.2 |
A: Ch 5, 134-154
B: Ch 9, 5 |
||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 2/13 |
Quiz 1
Review Relational Algebra |
|||
| Thursday, 2/15 |
SQL Data Types
Study Sheet 4.2 |
A: Ch 6 pgs 157-176
B: Ch 3,4,5 MySQL Data Types Quick Reference by Kim Briggs |
||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 2/20 |
Views and Access Control
Study Sheet 5.1 |
A: Ch 6 pgs. 176-197 |
HW3 - A: Problems 6.17, 6.18; 10 points; due Thursday 2/22
Project 1 due today Project 2 Due Thursday March, 29th |
|
| Thursday, 2/22 |
Stored Procedures
Study Sheet 5.2 |
B: Ch 14
Database Journal article on stored procedures. MySQLDevelopment.com article on stored procedures. Database Journal continuation of article on stored procedures. Brainbell's tutorial on using stored procedures. |
||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 2/27 | No Class - Trinity Days | |||
| Thursday, 3/1 |
Cursors
Introduction to the ER Model Study Sheet 6.2 |
Introduction to the E-R Model including an example.
Overview of E-R Model from University of Texas, Austin. Detailed presentation of E-R Model in an easy to navigate format. |
HW4 due Tuesday March 6, 2007. | |
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 3/6 |
ER Model
Study Sheet 7.1 |
A: Ch 11 | ||
| Thursday, 3/8 |
Prof. Ellis away
Midterm Exam |
|||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 3/13 |
Enhanced ER
Normalization Study Sheet 8.1 |
A: Ch 12, 13 | HW5 - A: Problems 13.16; 10 points; due Tuesday March 27. | |
| Thursday, 3/15 | Normalization | A: Ch 14 | ||
|
|
||||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 3/27 |
Normalization
Study Sheet 9.1 |
A: Ch 14 | HW6 due Tuesday April 3, 2007. | |
| Thursday, 3/29 | Conceptual Database Design | A: Ch 15 |
Project 3 Due 11:20 a.m. Thursday April,26th via email
Project 2 due today |
|
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 4/3 | Logical Database Design |
A: Ch 16
Applied Information Science's description of the difference between conceptual, logical, and physical models. |
||
| Thursday, 4/5 |
Physical Database Design
Quiz 2 |
A: Ch 17
Transitioning from logical to physical model article from Builder.com |
||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 4/10 | Tuning Performance | A: Ch 18 | ||
| Thursday, 4/12 |
Security
Study Sheet 11.2 |
A: Ch 19 except 19.3 and 19.4. | ||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 4/17 |
Transaction Processing
Study Sheet 12.1 |
A: Ch 20, pp. 572-594 | HW7 - A: Problems 20.18, 20.19 (15 points) Due Tuesday, 4/24. | |
| Thursday, 4/19 |
Transaction Processing cont.
Study Sheet 12.2 Study Sheet 12.2 PDF |
A: Ch 20, pp. 594-622 | ||
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 4/24 |
Transaction Processing cont.
Study Sheet 13.1 Study Sheet 13.1 PDF |
HW8 - A: Problems 20.22, 20.25 (10 points) Due Tuesday, 5/1. | ||
| Thursday, 4/26 |
Semistructured data and XML
Intro to XML slides in PDF |
A: Ch 30 | Project 3 due today | |
| Date | Topic | Reading/Activity | Assignment | |
| Tuesday, 5/1
(Last day of class.) |
Wrap up
Quiz 3 |
|||
|
|
||||
