CSC 443 - Data Base Management Systems

Dr. R. M. Siegfried

214 Post Hall           (516)877-4482           siegfrie@adelphi.edu

Office hours: MWF 9:00-9:50 & 12:00-12:50PM

Below you will find links to various class handouts that have been converted into web pages:

• Lecture #1 - An Overview of Databases and Transactions
• Lecture #2 - Databases: The Big Picture
• Lecture #3 - The Relational Data Model
• Lecture #4 - Conceptual Modeling
  • Draft of Library's Conceptual Model
• Lecture #5 - Normalization
• Lecture #6 - SQL As A Data Definition Language
• Midterm Study Questions
• Lecture #7 - SQL As A Data Manipulation Language
• Lecture #8 - More Complex Queries in SQL
• Lecture #9 - Introduction to Relational Algebra
• Lecture #10 - Views
• Assignment 10 Answers
• Lecture #11 - SQL Procedures and Triggers