DATABASE SYSTEMS
Professor: Leonid
Libkin
Class meets: Tuesdays 11:10am-1pm in HRB LTRB
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)
Requirements:
- 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
Textbook (recommended): Ramakrishnan-Gehrke Database Management Systems
Announcements:
- 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.
Lecture materials: