ICOM 5016 – Introduction to Database Systems (Fall 2015)

Introduction to Database Management Systems, with emphasis on relational database design and application development. Study of Entity-Relationship Model, Relational Model, Object-Oriented Model and Object-Relational Model. Techniques for database design: E-R modeling , UML modeling, E-R to relational mappings, functional dependencies, and normalization. Discussion of Structured Query Language (SQL), Applications servers and DBMS, XML and Web applications. Introduction to Transaction Processing and Database Recovery. Overview of DBMS implementation techniques: Storage Management, Indexing and Access Methods, Query evaluation and optimization.

General Information

  • Course Information Sheet A.K.A. Prontuario (PDF)

Lecture Tu & Th (2:00-3:15 PM) @ Stefani 113

  • Lecture 1.Overview of Database Management Systems (PPT)
  • Lecture 2. Sets and Relations (PPT)
  • Lecture 3. Entity-Relationship Modeling (PPT)
  • Lecture 4. Introduction to the Relational Model (PPT)
  • Lecture 5. Relational Algebra and Formal Query Languages (PPT)
  • Lecture 6. Basic SQL (PPT)
  • Lecture 7. Intro to Web Application Development (PPT)
  • Lecture 8. Database Normalization (PPT)
  • Lecture 9: Transactions (PPT)
  • Lecture 10: Concurrency Control (PPT)
  • Lecture 11: Storage Organization and Media (PPT)
  • Lecture 12: RAID and Buffer Management (PPT)
  • Lecture 13: File Organization and Structures (PPT)
  • Lecture 14: Indexing (PPT)
  • Lecture 15: Recovery System (PPT)
  • Lecture 16: Advanced Topics

Exams

  • Exam 1: Sept 22 8-10PM @ S-113 (Solution)
  • Exam 2: Oct 20   8-10PM @ S-113 (Solution)
  • Exam 3: Nov 17  8-10PM @ S-113 (Solution)
  • Final Exam: Place and Data TBA

Term Project

  • Project Specification (PDF)

Grades:

  • You may access your grades in the eCourses (Moodle) system