An "A" level student will
The primary texts for the course are Database Systems Concepts by Silberschatz, Korth and Sudarshan and SQL : A Practical Guide for Developers by Donahoo and Speegle. JDBC: A Practical Guide for Java Programmers by Speegle is a helpful text.
Other tools and references for the course:
| Old Exams | |||||
|---|---|---|---|---|---|
| Fall 2008 | Exam 1 | Exam 2 | Exam 3 | Final | Tables for SQL |
| Spring 2009 | Exam 1 | Exam 2 | Exam 3 | Final | Tables for SQL |
| Week | Reading/Topic | Assignment (due Friday) |
|---|---|---|
|
1 |
Database (Chapter 1 - sks) Baisc Queries (Chapter 2 -- ds) |
SQL 1 |
|
2 |
JDBC (Section 4.5 -- sks) | SQL 2 |
|
3 |
Single Table Queries (Chapters 3-4 -- ds) Mon: Labor Day |
SQL 3 |
|
4 |
Multiple Table Queries (Chapters 5-7 -- ds) |
SQL 4 |
|
5 |
Modifications (Chapter 8 -- ds)
Mon: Last drop day w/o grade |
Exam I |
|
6 |
Entity-Relationship Model (Chapter 6 -- sks) | DB 1 |
|
7 |
Database Creation (Chapter 8 -- ds) |
SQL 5 |
|
8 |
Functional Dependencies (Sections 7.1-7.4 -- sks) Fri: Fall Break |
DB 2 |
|
9 |
Normalization (Section 7.5 -- sks) Tue: Last day to drop w/o automatic DF |
DB 3 |
|
10 |
Web/Database Aps (Chapter 8 -- sks) Slides Project |
Exam II |
|
11 |
Mon Indexes (or Indices) (Section 12.1-12.8 -- sks) Wed Query Processing (Section 13.5 --sks) TPC Fri Transaction Processing (Chpater 15 -- sks + Chapter 11 -- ds) | SQL 6 |
|
12 |
Mon Recovery Wed Recommender Systems Fri Data Mining (Section 18.4 -- sks) | DB 4 |
|
13 |
Mon Information Retrieval (Chapter 19 -- sks) Wed ORM Fri Big Table Dilbert |
|
14 |
Wed-Fri: Thanksgiving |
November 23 Exam III |
15 |
Project Presentations - Mon: Wed: Fri: |
|
|
16 |
Project Presentations - Mon: |
|
Final Exam: 12/12 @ 2:00