Basics in databases (581328-9)
spring 2000
What's new
Lectures
Exercises
Exam
Requirements
Topics
Material
Finnish page
 
Topics

  • What is a database
    Elmasri&Navathe (2 and 3): Ch 1
  • Data models
    Elmasri&Navathe 3: Ch 2.1, pages 23-27 or
    (Elmasri&Navathe 2: Ch 2, pages 23-28)
  • Database system
    Elmasri&Navathe 3: Ch 2.2 -2.6, pages 27-39
  • The relational model of data
    • key
    • foreign key
    • referential integriy

    Elmasri&Navathe 3: Ch 7.1-7.2, pages 195-208 or
    (Elmasri&Navathe 2: Ch 6, pages 137-149)
  • Relational algebra
    Elmasri&Navathe 3: Ch 7.4, pages 211-224 (division excluded), 7.5.3, 7.6, 7.7 pages 228-235 or
    (Elmasri&Navathe 2: Ch 6.5, pages 153-164 (division excluded))
  • SQL
    • SQL data definition
      Elmasri&Navath 3: Ch 8.1 pages 243-251       or
      (Elmasri&Navathe 2: Ch 7.1 pages 186-192)
    • SQL queries, the basics
      Elmasri&Navathe 3: Ch 8.2, pages 251-261 or
      ( Elmasri&Navathe 2: Ch 7.2-7.2.8, pages 192-205)
    • SQL queries, features
      Elmasri&Navathe 3: Ch 8.3, pages 261-275. or
      (Elmasri&Navathe 2: Ch 7.2.9, 7.2.10 205-211.
    • SQL views
    • SQL data manipulation
      Elmasri&Navathe 3: Ch 8.4-8.5, pages 275-282 o.
      (Elmasri&Navathe 2: Ch 7.3, 7.4 pages 212-219)
  • Database applications
  • Introduction to database design
    Elmasri & Navathe 3: Ch 14.1