Lecture Notes

• Lecture 1 - Introduction
• Lecture 2 - Sets and Relations
• Lecture 3 - Entity-Relationship Model, l
• Lecture 4 - Entity-Relationship Model, Il
• Lecture 5a - Entity-Relationship Model, III
• Lecture 5b - Relational Model
• Lecture 6 - Relational Algebra
• Lecture 7 - Term Project
• Lecture 8 - Relational Algebra II
• Lecture 10-15 - SQL
• Lecture X - Integrity Constrains
• Lecture X - Normalization and DB Design
• Lecture X - Storage Organization
• Lecture - Storage Organization II
• Lecture - File Structures
• Lecture - Indexing
• Lecture - Transactions I
• Lecture - Transactions and Concurrency

Supplementary Readings

On-Line Text Book Chapters

• Chapter 3 - E-R Model
• Chapter 4 - Extended ER Model and UML

Java References

• Core Servlets and Java Server Pages
• Java Language Tutorial
• Java JDBC
• Java Servlet, JSP and Web Services

Practice Exercises

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