CSE255: Introduction to Databases

COURSE/CLASS MATERIALS   CSE255 Introductory Overheads: Display PPT CSE255 Course Announcements:   PPT Project Groups:  MS WORD or PDF Semester Project Fall 07 Presentation:  PPT Semester Project Fall 07 - Phase I:  MS WORD or PDF Semester Project Fall 07 - Phase II:  MS WORD or PDF Semester Project Fall 07 - Phase III:  MS WORD or PDF MySQL:  PPT and SampleCode Semester Project Individual Contribution:  MS WORD or PDF Semester Project Final Self Assessment:  MS WORD or PDF Addison-Wesley - DB Methodology Presentation: PDF Midterm Exam Advice:  PPS Exam Schemas:  INVENTORY,  BBALL and TVSHOW Final Exam Advice: PPT and Handout:  PDF Midterm Exams:  Sp03PDF, Fa03PDF,  Fa04PDF All Semesters - Midterm Solution: PPT Homework 1:  MS WORD or PDF Homework 2:  MS WORD or PDF Homework 3:  MS WORD or PDF Homework 4:  MS WORD or PDF Homework 5:  MS WORD or PDF Sample QO/CC Problems and Solutions:   PPS

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 Personal Oracle MYSQL Ghostview/Ghostscript to View Postscript Files on PC  The Java Series On-Line  Sun's Detailed Java Documentation Sun's JDBC Code Samples CSE255 JDBC Code Samples (zip) CSE255 JDBC Sample Oracle/Access (zip) Sun's Java Home Page  Download Java 1.4 J2SE Eclipse Borland's JBuilder Sun One Community Edition

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 8 Overheads -  Display: PPS Sample SQL Creates and Views:  Schema (Word), LicView (Word), CA View (Word) Readings: Chapter 8  of Textbook 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  Readings: Software Design (PS)  Overheads: PPT Readings: Overview on Java/Risks & BenefitsPostscript or PDF  Java Slides: PPT Java Risks and Benefits: PPT Software Requirements Specification: PPT UML: UNIFIED MODELING LANGUAGE  WebSites: OMG/UML & TOGETHER PRESENTATIONS Readings: UML Introduction & UML Specification - Different Formats  Overheads: UML Overview (PPT) & UML Example (PPT) Rational Overheads: Booch PPT, Rumbaugh PS, Jacobsen PPT

Dr. Steven A. Demurjian, Professor
Director of Graduate Studies
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