DATABASE SYSTEMS

NOTE: This is the 2011 version. For the most recent webpage, visit this page and navigate from there.

Professor: Leonid Libkin
Class meets: Tuesdays 11:10am-1pm in DHT FRN

Syllabus:

• Introduction to databases
• Relational model, algebra, calculus
• Basics of SQL programming
• Advanced SQL programming
• Database design and normalization
• Basics of query and transaction processing
• Introduction to XML (data format and query languages)

• Exam (75%)
• 3 assignments:
  

• Assignment 1: relational model, algebra, calculus, simple SQL (pencil-paper, 5%);  due 21 October (ITO, 4pm)
  
• Assignment 2: SQL programming (15%), due 18 November
  Using PostgreSQL on dice machines
  PostgreSQL tutorial 1
  PostgreSQL tutorial 2
  
• Assignment 3: normalization, query/transaction processing, XML (pencil-paper, 5%), due 25 November
  

• ROOM CHANGE: DHT FRN (starting Tuesday 4/10)
• Class on Tuesday 1/11 will be given by Juan Reutter

• Introduction
• Relational model
• SQL programming I
• SQL programming II
• Database design I
  
• Design and constraints
  
• Query and transaction processing
  
• Introduction to XML