Course Schedule and Materials

Attention: schedule is tentative and will be updated! - Last updated on Nov 27, 2010

*  This schedule is used for two class sections. The session dates shown only indicate Mondays of all weeks.
** Reading chapters from the textbook notation (depending on your choice of the textbook):
- DP: Database Processing, by Kroenke and Auer, 11th edition.
- DC: Database Concepts, by Kroenke and Auer, 5th edition.

Session*

Topics / Activities / Readings**
Lecture Notes / Tutorials / Downloads
1. 08/23/2010

Course overview; attendance; survey; experiment pre-test.

Reading: Syllabus

Downloads: Syllabus

Part 1: Designing Relational Database

2. 08/30/2010

Introduction to Relational Database

Reading:
- DP: chapter 1, chapter 3 (part 1)
- DC: chapter 1, chapter 2 to p.63
- Overview of SQL Server 2008 R2 Express

Lecture Notes:
- Introduction to database
- Relational model

Tutorial: SQL Server 2008: Introduction

Downloads: database examples, get the Northwind SQL Server files:
- Northwind2003-mini.mdf
- Northwind2003-mini.ldf
3. 09/06/2010

Normalization

Reading:
- Normalization in Wikipedia: to 3NF
- DP: chapter 3 (part 2)
- DC: chapter 2 from p.64

Lecture Notes: Normalization
4. 09/13/2010

Database Design using ERD

Reading:
- Database development life cycle (section 2 to 6)
- DP: chapter 5
- DC: chapter 4
- Basic Tasks in Visio 2010

Lecture Notes:
- Relational database design
- Conceptual Design using ERD

Tutorial: Visio 2010: Intro and ERD

Download: Visio stencil and examples
5. 09/20/2010

Logical Design

Reading:
- DP: chapter 6;
- DC: chapter 5, online Appendix D

Lecture Notes: Logical Design

Tutorial: Visio 2010 Database Diagram

Download: Visio stencil and examples (same as last week)
6. 09/27/2010

Physical Design and Implementation

Reading:
- DP: chapter 7 (DDL)
- DC: chapter 3 p.106-117, online Appendix A

Lecture Notes: Physical Design and SQL DDL

Tutorial: SQL Server 2008: creating tables and editing data

Download: database examples (SQL-DDL-Example.sql)
7. 10/04/2010

Mid-term Exam

Exam Guide

Part 2: Managing and Using Data
8. 10/11/2010

Database Applications

Reading:
- DP: chapter 7, 10, 11
- DC: chapter 7 p.362-368

Lecture Notes:
- Database Applications and Programmability Overview

Tutorial: SQL Server 2008 for MS Office
9. 10/18/2010

SQL Query

Reading:
- sqlcourse2.com
- DP: chapter 2, chapter 10
- DC: chapter 3 p.118-146, online Appendix A

Lecture Notes: Database Query: SQL SELECT Basics

Tutorial: SQL Server 2008: Database Query
10. 10/25/2010

Advanced SQL Query

Reading:
- DP: chapter 2, chapter 7
- DC: chapter 3

Lecture Notes: Advanced SQL Query
11. 11/01/2010

Designing XML Data

Reading:
- DP: chapter 12
- DC: chapter 7 p.382-397

Lecture Notes: XML and Data: Introduction

Download: XML examples
12. 11/08/2010

XML Schema

Lecture Notes: XML Schema
13. 11/15/2010

Business Intelligence

Reading:
- DP: chapter 13
- DC: chapter 8

Lecture Notes:
- Business Intelligence
- Data Warehouse and OLAP

Download: miniDW.mdf and miniDW.ldf (in database examples)

Tutorial: Pivot Table and Diagram with Excel, Visio and SQL Server
 11/22/2010

Thanksgiving Break

  
14. 11/29/2010

Experiment post-test; semester summary

  
15. 12/06/2010

Final exam:
1. Wednesday 4:30PM
2. Thursday 8:00AM

Final exam guide