CMPS 4123: Database Management Systems

Spring semester 2006

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

TR  9:30 - BO 212

 

Course Description:

A study of concepts, characteristics, design and implementation of database management systems, including hierarchical, network, and relational data-models; appropriate data structures, operations and query languages. Other topics that will be discussed include normal forms and query by example techniques.


Text book:
Database Management Systems, by R. Ramakrishnan.

Lecture Notes:

CMPS 4123-part 1

CMPS 4123-part 2

CMPS 4123-part 3

CMPS 4123-part 4

CMPS 4123-part 5

Project Database:

Database file

Agenda: 

January     February     March     April     May     Grading

January

Jan 17-

Introduction to DBMS

Chapters 1 to 5

Jan 19-

Queries in a DBMS

 

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-

Logical DB Design

 

Feb 16-

Views

 

 

Assignment # 3

 

Feb 21-

Relational Algebra – Selection and Projection

 

Feb 23-

Relational Algebra – Joins and Division

 

 

Assignment # 4

 

Feb 28-

SQL - Basics

 


March

Mar  2-

SQL – Nested queries

 

Mar  7-

Review

 

Mar  9-

Test # 1

 

Mar 14-

Spring Break

 

Mar 16-

Spring Break

 

Mar 21-

SQL – Aggregate Operations

 

Mar 23-

SQL – Null Values

 

Mar 28-

SQL – Integrity Constraints

 

Mar 30-

Schema Refinement

Chapter 19

 

Project assignment

 

 

Assignment # 5

 

April

Apr  4-

Normalization – BCNF and 3rd NF

 

Apr  6-

Normalization - Decomposition

 

 

Assignment # 6

 

Apr 11-

Transaction Management

Chapter 16

Apr 13-

Easter Holidays

 

Apr 18-

Lock Based Control

 

Apr 20-

Test # 2

 

Apr 25-

Application Development

Chapter 6

Apr 27-

Microsoft Access - QBE

 

May

May  2-

Embedded SQL – C++

 

May  4-

Embedded SQL – PHP

 

May  9-

Finals (Tuesday, 8:00 am)

 

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