Skip to content

Part I · SQL and relational algebra

The first partial exam: short questions on integrity constraints and on the size of relational expressions, then SQL queries on eight schemas, from simple joins to grouping, views and "maximum, ties included".

Topic Exercise
Theory Integrity constraints and cardinality of relational expressions
SQL Investment platform: clients, accounts and orders
Composers, pieces and concerts
Customers, orders and instalments
A museum: artists, paintings and rooms
Countries, cities and departments
Union of two relations
Bookshops, books and availability
Flights and airports