DATABASE SYSTEMS
Professor: Leonid
Libkin
Class meets: Mondays and Thursdays 9-9:50 in AT LT5
Tutorials start the week of 30 September. Additional
information
is here.
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 16 October (ITO, 4:30pm)
- Assignment 2: SQL programming (15%), due 12
November, 4:30pm, see the assignment for submission instructions
Using PostgreSQL on dice machines
PostgreSQL tutorial 1
PostgreSQL tutorial 2
- Assignment 3: normalization, query/transaction processing, XML (pencil-paper,
5%), due 22 November (ITO, 4:30pm)
Textbook (recommended): Ramakrishnan-Gehrke Database Management Systems
Announcements:
- The first class is scheduled for Monday the 16th which is a
public holiday in Edinburgh - meaning that schools are closed. This
may create insurmountable difficulties for the instructor. Please
check this page on Sunday before heading to
class.
UPDATE (Sunday 15/09): Please do come to class. The first lecture
will be given by Dr Diego Figueira. All announcements about class
orgnization will be made on Thursday. If you have urgent questions
that cannot wait until Thursday, please email me - I am around but
cannot make it to the University on Monday.
Lecture materials: