CS U430 Database Design

UNDER CONSTRUCTION

Spring 2006
 

 Week 

Topic

Homework Assignments

Reading

Jan 9th

Introduction to Databases; Relational Algebra; Relational Databases, Load Dream Home database. Link to MS SQL database Reset your MS SQL password

Slides1 Slides 2

Chap1 & part of Chap 2

Jan 16

 

Load CAPS database (see textbook page 27-28)

 

RELATIONAL DBs: Primary key; Relational Integrity;
SQL: Simple Queries, DISTINCT, Calculated Fields, WHERE clause

 

SQL: Sorting Results, SQL Aggregate Functions, Grouping Results
Lab Session

 

SQL: Multi-table Queries (Inner Join, Outer Join)

 

SQL: Subqueries (EXISTS, NOT EXISTS), Division, Minus
SQL: Combining Result Tables

HW1 out

Slides 3

 

 

Chap 3

Jan 23

HW2 out

Slides 4

Slides 5

Jan 30

SQL: Database Updates, Review – insert(full fields or partly fields)/update

 

SQL: Data Definition - Foreign Key; Create&Alter Tables (review the creation of the tables/change the fields’ types/add foreign keys)

 

SQL: Data Definition - Create&Alter Tables

HW3 out

Slides 6

Feb 6

Procedural T-SQL, stored procedure, UDF, cursor, constraint, trigger, view

Slides 7

HW4 out

Chap 4.4

Feb 13

Feb 20

Entity-Relationship modeling

 

Transaction

HW5  out

Chap 6.1-6.2, Chap 10.1,10.4,10.5

Feb 27

Mar 13

Indexing for relational database, spatial database, multi-dimensional database (B-tree, KdB-tree, R-tree) .

HW6 out

Solution of HW6

Chap 8.1-8.4.

Handout papers 1 2 3

Mar 20

Mar 27

Web application programming (ASP, .Net)

HW7 out

Sample results of HW7

Problem 1 2 3 4 5 6

Course material

Apr 3

Apr 10

Project: a simple web-based application which combines all the knowledge we have learned from this course. You should analyze the application, design the database (ER diagram), created the database, populated the databases, create the web interface for the database.

Project out

 

Apr 17

Schedule

 

Apr 24

Final exam

Review material

Solution of Quiz2

Close book

 

  • Jan 16th, Feb 20th and April 17th  are holidays, no class.
  • March 6-12 are sparing break, no class.