Carnegie Mellon University
GSIA

[70-455] – Information Resource Management
Spring 2001

Tuesday 6:30 - 8:50pm
Simon Auditorium, GSIA Building

"Final" Grades

Instructor:  Kevin Stolarick
kms@andrew.cmu.edu

Course Materials

Syllabus

Homework #1 - Happy Valley Kennels        Notes/Questions
Homework #2 - Database Jobs        Notes/Questions
Homework #3 - E-R Modeling        Notes/Questions
Homework #4 - Relational Schemas        Notes/Questions
Homework #5 - SQL 1        Notes/Questions       Answer Key
Homework #6 - SQL 2        Notes/Questions       Answer Key
Homework #7 - Normalization        Notes/Questions       Answer Key  (Word format)
Homework #8 - Database Administration        Notes/Questions       Answer Key
Homework #9 - Distributed Databases        Notes/Questions       Answer Key
Homework #10 - OO Databases        Notes/Questions
Homework #11 - Data Warehousing & Data Mining        Notes/Questions (Combined with HW #10)

Course Presentations (PowerPoint)
1/16 Overview
1/23 Database Development
1/30 E-R Modeling I
2/6   E-R Modeling II
2/13 Relational Model
2/20 Midterm Exam 1        Sample Exam        Exam Key
2/27 SQL I
3/6   SQL II; Other Query Methods
3/13 Normalization
3/20 Midterm Exam 2        Sample Exam
3/37 Spring Break
4/3   Physical Database Design
4/10 Database Administration
4/17 Client-Server; Distributed Databases
4/24 Object-Oriented Databases
5/1   Data Warehousing & Data Mining (combined with 4/24)
TBA Final (5/1)        Sample Exam