Database and algorithms (MAT0040)
MATERIALE DIDATTICO
AA 2019/2020
Exercises
Link
Plans
AA 2018/2019
Exercises
- Additional exercise on SQL
- Exercise #1 on ER
- Exercise 1 on the relational model
- Exercise 2 on the relational model
- Exercise 2 on the relational model - solution
- Exercise n. 6 on relational algebra
- Exercise on Complete Database Design
- Exercise on conceptual design
- Exercises on GROUP BY
- Exercises on nested queries
- Exercises on nested queries and aggregates
- Exercises on SQL: initial exercises
- Exercizes from Past Exams (zip file)
- Exercizes on INSERT, DELETE, UPDATE, VIEWS
- Homework on Relational Algebra
- Solution to exercize 6.5
- Test exam
- Test Exam #2