CMPS 5303: Advanced Database Management Systems

Spring semester 2005

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

MW  7:00 - BO 320


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

Agenda:

January     February     March     April     May     Grading

January


Jan 17-

Martin Luther King Day

 

Jan 19-

Introduction to DBMS

Chapters 1 to 5

Jan 24-

Overview of a Relational DB

 

Jan 26-

E-R Diagrams

 

Jan 31-

Relationships

 



February


Feb   2-

Conceptual Design

 

 

Assignment # 1

 

Feb  7-

Relational Model

 

Feb  9-

Keys

 

 

Assignment # 2

 

Feb 14-

Views

 

Feb 11-

Relational Calculus

 

 

Assignment # 3

 

Feb 21-

SQL - Basics

 

Feb 23-

SQL Nested queries

 

 

Assignment # 4

 

Feb 28-

SQL Null Values

 



March


Mar  2-

Schema Refinement

Chapter 19

Mar  7-

Normalization

 

Mar  9-

Test # 1

 

Mar 14-

Spring Break

 

Mar 16-

Spring Break

 

Mar 21-

Normalization

 

Mar 23-

Storage and Indexing

Chapter 9, 8

Mar 28-

File Organizations (C++ Direct Access)

 

Mar 30-

Tree Structure Indexing

Chapter 10, 11

 

Project assignment

 

 

Assignment # 5

 



April


Apr  4-

B+ Trees

 

Apr  6-

Hashing

 

 

Assignment # 6

 

Apr 11-

Transaction Management

Chapter 16 to 18

Apr 12-

Concurrency

 

Apr 18-

Crash Recovery

 

Apr 20-

Test # 2

 

Apr 25-

Test Review

 

Apr 27-

Web/Database Interaction - Overview (student presentations)

 



May


May  2-

Data Mining - Overview (student presentations)

 

May  4-

Data Warehouses - Overview (student presentations)

 

May  9-

Finals (Tuesday, 7:30 pm)

 



Grading



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


E-mail address:

nelson.passos@mwsu.edu

Back to Dr. Passos Home Page