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

CSE4701: Principles of Databases

COURSE/CLASS MATERIALS
  • Course IntroPPTX   and  Announcements:   PPTX
  • OtherTechnologies: MS WORD
  • Sample Problems:  PPTX
  • Addison-Wesley - DB Methodology Presentation: PDF
SEMESTER PROJECT/RELEVANT LINKS
COURSE LECTURES AND READING MATERIALS
  • Chapters 1 & 2 6e & 5e - Introduction: PPTX
  • Chapter 3 & 6 6e & 7 5e - Relational Model Parts 1 & 2: PPTX
  • Chapter 4  6e & 8 5e -Basic SQL: PPTX
  • Chapter 5 6e & 8 5e - Advanced SQL: PPTX
  • SQL Examples: DDL PPTX and DML PPTX
  • Samples:  Schema, LicView, CA View 
  • Chapters 7 & 8 6e - 3 & 4 5e - ER Model: PPTX
  • Chapter 9 6e, 5 6e - ER to Relat Trans:  PPTX and EERSolns
  • Chapter 15 & 16 6e, 14 5e  - DB Design/Normalization: PPTX
  • Chapter 10 6e - Database Design: PPTX
  • Chapter 12 6e - XML: PPTX

  • Chapter 13 & 14 6e - SQL/PHP: PPTX & Other PPTX
  • Chapters 17 & 18 6e, 13 & 14 5e - Design/Storage/Index: PPTX
  • Chapters 19 6e, 17 & 18 5e - System Catalog/Query Opt:  PPTX
  • Chapters 21 & 22 6e, 19 & 20 5e - Trans Proc/CC: PPTX
  • Chapter 23 6e, 21 5e - Recovery:  PPTX
  • Chapter 24 6e, 22 5e -  Security: PPTX
  • Chapters 25 6e, 24 5e  - Distributed Databases: PPTX
  •  Dynamic Coalition Problem  - Overheads: PPTPaper
  • UML Intro and PPTs & Example (PPT)

Dr. Steven A. Demurjian, Sr., Professor
Co-Director of Research, Biomedical Informatics Division
Computer Science & Engineering, Box U-4155
The University of Connecticut
371 Fairfield Road, Storrs, Connecticut 06269-4155
(860) 486-4818, (860) 486-3719 (CSE Office), (860) 486-4817 (fax) ..
steve@engr.uconn.edu