DATABASE SYSTEMS

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 19 October (ITO, 4pm)
  
• Assignment 2: SQL programming (15%), due 16 November
  Using PostgreSQL on dice machines
  PostgreSQL tutorial 1
  PostgreSQL tutorial 2
  
• Assignment 3: normalization, query/transaction processing, XML (pencil-paper, 5%), due 27 November
  

• Due to wrongly set permissions, file hw3.pdf with the 3rd assignment was not available for download until 13 November. The file is available now, and the new due date is 27 November.

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