Andrew Pletch
Assistant Professor of Computer Science
Faculty Office Building N-01
Address:
Department of Computer Science
State University of New York New Paltz
75 South Manheim Blvd.
New Paltz, New York 12561
Phone: (845) 257-3556
Fax: (845) 257-3996
E-Mail:
pletcha@newpaltz.edu
Office Hours (Fall 2009)
By Appointment
Courses:
Database Principles
Course Outline
Course PowerPoints
Additional PowerPoints
Conceptual Modeling
Database History
Three Questions for Database Design
Entities and Relationships
Entity Relationship 1
Entity Relationship 2
Ten Steps to Database Design
The Library Database
Answer to Homework #2
Bearcat Industries ER Diagram
ER Homework #2 Answer
Assignment 4: Participation Number Homework Answers
Entity Relationship to Relational Data Model Mapping
Relational Algebra
Venn Diagrams
Connecting to DB2
Relational Alegbra Examples
Library Database Data Files
SQL Notes 1
SQL Notes 2
Hard Query Errors
Characteristic Functions
Characteristic Function Source Code
DB2 Temporary Tables
SQL Homework #2 Answers
Relational Database Design I
Assignment 8: SQL Homework #3: Answers
Assignments
Assignment 1: Conceptual Model of an Elephant: Due September 4
Assignment 2: ER Diagram Homework Due September 8
Assignment 3: Entity Relationship: Due September 17
Assignment 4: Participation Number Homework: Due September 29
Assignment 5: Relational Algebra Homework: Due Oct 16 and Oct 23
Assignment 6: SQL Homework #1: Hand in and Quiz October 30
Assignment 7: SQL Homework #2: Hand in and Quiz November 6
Assignment 8: SQL Homework #3: Hand in and Quiz November 13
Object Oriented Programming
Course Outline
Course Slides
Chapter 1
Object Abstraction
Java Visibility Modifiers
Chapter 2
Implementation Approach
Controller Class Diagram
Controller State Diagram
Vending Machine CRC
Vending Machine Use Case
Vending Machine State Diagram
Vending Machine Sequence Diagram
Vending Machine Class Diagram
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 9
Homeworks
pletcha@newpaltz.edu
