upprevious
Up:Steven A. Demurjian's Home Page Previous:Current and Previous Courses/Materials

CSE255: Introduction to Databases

COURSE/CLASS MATERIALS  
PAST PROJECTS
  • Semester Project Fall 04:  MS WORD or PDF
  • Semester Project Fall 03:  MS WORD or PDF
  • Semester Project - Phase III Updated Spec Fall 03:MS WORD or PDF
  • REVISED Semester Project Overheads Fall 03:PPT
  • ER Diagrams/Specs - Phase II Solutions Fall 03:MS WORD or PDF
  • CSE255 Spring 2003 Phase III: Report and Code
SOFTWARE DOWNLOADS AND WEBSITES
COURSE LECTURES AND READING MATERIALS
CHAPTERS 1 AND 2: INTRODUCTION
  • Overheads -  Display: PPS
  • Readings: Chapters 1 and 2 of Textbook
CHAPTERS 3 AND 4: THE ENTITY RELATIONSHIP MODEL
  • Overheads -  Display: PPS
  • Readings: Chapters 3 and 4 of Textbook
CHAPTER 7: THE RELATIONAL  MODEL
  • Chapter 7 Overheads -  Display: PPS
  • Readings: Chapter 7  of Textbook
CHAPTER 8: THE RELATIONAL  MODEL
CHAPTER 9: ER TO RELATIONAL TRANSFORMATION
  • Chapter 9 Overheads -  Display: PPS
  • Readings: Chapter 9  of Textbook
CHAPTER 14: FUNCTIONAL DEPENDENCIES AND NORMALIZATION IN DATABASES
  • Chapter 14 Overheads -  Display: PPS
  • Readings: Chapter 14 of Textbook
CHAPTERS 12,13, 14: DESIGN, STORAGE, INDEXING - 5th EDITION
  • Chapter 12, 13, 14 Overheads -  Display: PPTp1  and  PPTp2
  • Readings: Chapter 12, 13, and 14  of Textbook (5th Edition)
CHAPTERS 17 AND 18: SYSTEM CATALOG AND QUERY OPTIMIZATION
  • Overheads -  Display: PPS
  • Readings: Chapter 17 and 18 of Textbook
CHAPTERS 19 AND 20: TRANSACTION PROCESSING AND CONCURRENCY CONTROL
  • Overheads -  Display: PPS
  • Readings: Chapter 19 and 20 of Textbook
CHAPTER 21: RECOVERY
  • Chapter 21 Overheads -  Display: PPS
  • Readings: Chapter 21  of Textbook
CHAPTER 22: SECURITY
  • Chapter 22 Overheads -  Display: PPS
  • Dynamic Coalition Problem  - Overheads: PPT
  • Readings: Chapter 22  of Textbook and DCP Paper
CHAPTERS 24, 26, 27: DISTRIBUTED DBMS, DATA WAREHOUSES AND DATA MINING, WEB-BASED DB ARCHITECTURES
  • Chapters 24, 26, 27 Overheads -  Display: PPS
  • Chapters 24 and 27 Overheads -  Display: PPS
  • Readings: Chapters 24, 26, and 27  of Textbook
SOFTWARE  DESIGN, JAVA, REQUIREMENTS 
UML: UNIFIED MODELING LANGUAGE 
Dr. Steven A. Demurjian, Professor
Co-Director of Research, Biomedical Informatics Division
Computer Science & Engineering, Box U-2155
The University of Connecticut
371 Fairfield Way, Storrs, Connecticut 06269-2155
(860) 486-4818, (860) 486-3719 (CSE Office), (860) 486-4817 (fax)
steve@engr.uconn.edu