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

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

- 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

Part 3: Database Applications and Management

Database Applications and Programmability

Reading:
- Chapter 10

- Lecture: advanced database query

* Assignment #6

- Database design  project deliverable #2: logical design due

Database Administration and Security

Reading:
- Chapter 9

** Research project presentation #1: database administration

** Research project presentation #2: SQL injection

- Assignment #6 Due

Data Warehouse and Business Intelligence

Reading:
- Chapter 13

** Research project presentation #3: business intelligence

XML in RDBMS

Reading:
- Chapter 12
- XML introduction on Wikipedia
- XML Basics; XML Schema;

* 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