Course Description

Introduction to Database Management Systems, with emphasis on relational database design and application development. Study of Entity-Relationship Model, Relational Model, Object-Oriented Model and Object-Relational Model. Techniques for database design: E-R modeling , UML modeling, E-R to relational mappings, functional dependencies, and normalization. Discussion of Structured Query Language (SQL), Applications servers and DBMS, XML and Web applications. Introduction to Transaction Processing and Database Recovery. Overview of DBMS implementation techniques: Storage Management, Indexing and Access Methods, Query evaluation and optimization.

Instructor

Manuel Rodriguez-Martinez, Ph.D.

Office: T-212

          Phone: (787)-832-4040, x-3023

          E-mail: manuel@ece.uprm.edu

          Office hours: 

Thursdays, 9:30 am - 10:30 am, T-212

Fridays, 2:30 pm - 4:30 pm, T-212

Lecture Time

Tu -Th 12:00pm-1:20pm, S-229

© 2004 University of Puerto Rico-Mayaguez. All rights reserved.