IT 244 - Database Management Systems

Teacher: Havili Movete - Email : h_movete@tihe.org

Text Book
  • "A first Course in Database Systems (Second Edition)", Jeffery Ullman, Jennifer Widom

    Course Outline and Course Time
  • IT 244 2010 Course Outline Click Here

    IT 244 Group 1 (Monday and Wednesday 5 - 7 pm) - For the CS Students
    IT 244 Group 2 (Tuesday and Thursday 5 - 7 pm) - For the IS Students

    2009 Lecture Notes
  • IT 244 Lecutre 1 Introduction to DBMS
  • IT 244 Lecutre 2 Practical 1
  • IT 244 Lecutre 3 Practical 2
  • IT 244 Lecutre 4 Topic 2
  • IT 244 Lecutre 5 Data Modelling Part 2
  • IT 244 Note 1 Normalisation Note 1
  • IT 244 Lecture 6 DBMS Overview
  • IT 244 Note 2 Summary MS Access
  • IT 244 Note 3 DBMS Security Issues
  • IT 244 Lecture 7 SQL
  • IT 244 SQL Quizz SQL Quizz

    2010 Lecture Notes
  • IT244 Topic1 Lecture 1
  • Intro to Database and DBMS
  • ER Data Modeling
  • Data Modeling PART 2
  • E-R Data Modeling
  • DBMS Overview
  • From ER to RDM
  • Normalisation
  • Design Principles
  • Relational Data Model
  • Normalization
  • Normalization Note
  • Normalization Note 2
  • SQL
  • DBMS Security Issues
  • Review Questions

  • Access Practical 1

    Homeworks
  • Review Questions Review Questions 1

    Sample Database
  • Sample Database 1 Student Record System
  • Sample Database 2 Northwind