Introduction to Databases (581328-9), Spring 2004

Topics

This course is intended as a first year course in Computer Science. It assumes basic knowledge on programming (in Java), WWW and HTML. The 'Database design' part of the course assumes knowledge about UML class diagrams (taught in the course Introduction to Appication Analysis and Design).

The course covers the foundationss of relational databases: structure and use of the database, SQL database language and principles of programming database applications (in Java). The following list of topics lists also textbook material that may be used in addition to the lectures and e-learning material. Two alternatives are given. The textbook Ramakrishnan & Gehrke is the current text book of the course Database Management thus if you are considering to continue your database studies, you might consider buying this book. Elmasri & Navathe was the previuos text book of Database Management, and is still valid. It might be easier to get in the student library. The current edition of Elmasri & Navathe is 4th (since September 2003), but the chapters below are the chapters of the 3rd edition.

  • What is a database
    Elmasri&Navathe: Ch 1
    Ramakrishnan & Gehrke: Ch 1
  • Data models
    Elmasri&Navathe: Ch 2.1, pages 23-27
    Ramakrishnan & Gehrke: Ch 1.5, 2.1
  • Database system
    Elmasri&Navathe: Ch 2.2 -2.6, pages 27-39
    Ramakrishnan & Gehrke: Ch 1
  • The relational model of data
    • domain
    • relation
    • key
    • foreign key
    • referential integriy

    Elmasri&Navathe: Ch 7.1-7.2, pages 195-208
    Ramakrishnan & Gehrke: Ch 3.1-3.3
  • Relational algebra
    Elmasri&Navathe: Ch 7.4, pages 211-224 (division excluded), 7.5.3, 7.6, 7.7 pages 228-235
    Ramakrishnan & Gehrke: Ch 2, 4.1-4.2
  • Introduction to database design
    Elmasri&Navathe: Ch 14.1
    Ramakrishnan & Gehrke: Ch 2, 19.1-19.4.1,19.6.1
  • SQL
    • SQL data definition
      Elmasri&Navath: Ch 8.1 pages 243-251
      Ramakrishnan & Gehrke: Ch 3.1.1-3.3.1
    • SQL queries, the basics
      Elmasri&Navathe: Ch 8.2, pages 251-261
    • Ramakrishnan & Gehrke: Ch 5.1-5.2, 5.6
    • SQL queries, additional features
      Elmasri&Navathe: Ch 8.3, pages 261-275.
      Ramakrishnan & Gehrke: Ch 5.3-5.4
    • Yhteenvetokyselyt
      Elmasri & Navathe: Ch 8.4
      Ramakrishnan & Gehrke: Ch 5.5
    • SQL views
      Ramakrishnan & Gehrke: Ch 3.6.
    • SQL data manipulation
      Elmasri&Navathe: Ch 8.4-8.5, pages 275-282
      Ramakrishnan & Gehrke: Ch 3.3.1
  • Database applications
    • Concepts
    • Java database programming - JDBC
      Harri Laine: Database programming
    • WWW- database applications
      Elmasri&Navathe: Ch 27.1
      Ramakrishnan & Gehrke: Ch 6.1-6.4, 7.5,7.6 ja 7.7 (only the main principles) .

SQL practicing is carried out with the automated SQLTrainer practice environment.

© Harri LaineUpdated: 11.3.2004, email: Harri.Laine@cs.helsinki.fi