Course overview

Reading: Syllabus

- Attendance and survey
- Database design project overview
- Research project overview
- Student groups

Introduction to Relational Database

Reading: chapter 1, chapter 3 (part 1)

Lecture:
- Introduction to database
- Relational model

Demo: SQL Server 2008 first look

* Assignment #1

SQL and Database Query

Reading: chapter 2, sqlcourse2.com, chapter 10

Lecture: Structured Query Language

Demo: Query in SQL Server 2008 (Northwind2003-mini)

- Database design project discussion

* Assignment #2 (amazonbooks)

- Finalizing student groups and project selection
- Assignment #1 Due

Database Design and Normalization

Reading:
- Database development life cycle (section 2 to 6)
- chapter 3 (part 2), 4, Database normalization from Wikipedia: up to the BCNF

Lecture:
- Database design
- Normalization

* Assignment #3

Database Design using ERD

Reading:
- Chapter 5

Lecture: Conceptual Design using ERD

Demo: Microsoft Visio 2007 (Visio example)

- Design project meeting: requirements

* Quiz #1

Database Design using ERD (continued)

Reading:
- Chapter 5

Lecture: Conceptual Design using ERD

Demo: Microsoft Visio 2007 (Visio example)

- Design project meeting: requirements

* Assignment #4

Logical Design

Reading:
- Chapter 6
- Teorey, Yang, and Fry, "A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model," Computing Surveys, 18(2)197-222, June 1986.

Lecture: Logical Design

Demo: Microsoft Visio 2007 (Visio example)

- Design project meeting: conceptual designs

* Assignment #5

Physical Design and Implementation

Reading:
- Chapter 7

Lecture: Physical Design and DDL

Demo: SQL Server 2008 (Script example)

- Database design project demo #1: conceptual models
A: SQLSecurity
B: Team mySQL

* Assignment #6

- Assignment #5 Due

Spring Break!

- Database design  project deliverable #1: conceptual design due

Exam

- Design project meeting: feedback on conceptual models

- Research project meeting

Database Design Summary

- Database design project demo #2: logical models
A: We Win
B: BI Guys

- Exam Summary

- Work on database project: feedback on logical models; final implementations

- Assignment #6 Due

Part 3: Database Applications and Management

Database Applications

Reading:
- Chapter 7, 10, 11

Lecture:
- Database applications and programmability
- Advanced SQL query

* Assignment #6

- Database design  project deliverable #2: logical design due

Database Administration

Reading:
- Chapter 9, 10

Lecture:
- Database Administration

** Research project presentation #1: Data Integration

** Research project presentation #2: SQL Injection

 Business Intelligence

Reading:
- Chapter 13

Lecture: Business Intelligence - miniDW.zip

** Research project presentation #3: Predictive Data Mining

XML and Database

Reading:
- Chapter 12

Lecture: XML and RDBMS

* Quiz #2

** Research project presentation #4: XML database

** Database design project demo #3: final implementation
A: IT Guys
B: Team mySQL (together with their research project presentation #5)

** Research project presentation #5: MySQL

Other group demos: optional

- Database design  project deliverable #3: final report due 5/3