CMPS 5303: Advanced Database Management Systems

Spring semester 2007

Instructor: Dr. Nelson L. Passos
Office: Bolin Science Hall 126B
Office phone: 397-4129
E-mail: nelson.passos@mwsu.edu
Office Hours: TW  9:00 - 12:00 pm
TR    3:00 - 5:00 pm
Class Hours:

TR    5:30 - BO 213


Course Description:

Study of the theory, design and implementation of database systems, including hierarchical, network, relational and object oriented data-models; appropriate data structures, file organizations, operations and query languages. Other topics that will be discussed include functional dependencies, normal forms, query optimization and file structures.

Text book:

Database Management Systems, by R. Ramakrishnan.

Lecture Notes:

CMPS 5303-part 1

CMPS 5303-part 2

CMPS 5303-part 3

CMPS 5303-part 4

CMPS 5303-part 5

CMPS 5303-part 6

CMPS 5303-part 7

Data file for assignment # 2

Data files for 2007 project (Excel files)

Agenda:

January             February             March             April             May             Grading

January


Jan 15-

Martin Luther King Day

 

Jan 16-

Introduction to DBMS

Chapters 1 to 5

Jan 18-

Overview of a Relational DB

 

Jan 23-

E-R Diagrams

 

Jan 25-

Relationships

 

Jan 30- Conceptual Design  



February


Feb  1-

Relational Model

 

 

   Assignment # 1

 

Feb 6-

Keys

 

Feb 8-

Views

 

 

Assignment # 2

 

Feb 13-

Relational Calculus

 

Feb 15-

SQL - Basics

 

 

Assignment # 3

 

Feb 20-

SQL Nested queries

 

Feb 22-

SQL Null Values

 

 

Assignment # 4

 

Feb 27-

Schema Refinement

Chapter 19



March


Mar  1-

Normalization

 

Mar  6-

Normalization

 

Mar  8-

Test # 1

 

Mar 13-

Spring Break

 

Mar 15-

Spring Break

 

Mar 20-

Storage and Indexing

Chapter 9, 8

Mar 22-

File Organizations (C++ Direct Access)

 

Mar 27-

Tree Structure Indexing

Chapter 10, 11

 

Project assignment

 

Mar 29-

B+ Trees

 

 

Assignment # 5

 



April


Apr 3-

Hashing

 

Apr 5-

Easter Break

 

Apr 10-

Transaction Management

Chapter 16 to 18

Apr 12-

Concurrency

 

 

Assignment # 6

 

Apr 17-

Crash Recovery

 

Apr 19-

Test # 2

 

Apr 24-

Test Review

 

Apr 26-

Web/Database Interaction - Overview (student presentations)

 



May


May  1-

Data Mining - Overview (student presentations)

 

May  3-

Data Warehouses - Overview (student presentations)

 

May  8-

Finals (Tuesday, 7:30 pm)

 



Grading



Tests: 20 % (each)
Presentation: 20 %
Assignments: 15 %
Project: 20 %
Class Participation: 5 %


E-mail address:

nelson.passos@mwsu.edu

Back to Dr. Passos Home Page