Database Systems I
Actual info
Summary of main documents
Test on SQL
- Data model of the RVVI database: pdf
- Test with the solutions
- Test2 with the solutions
- Sample SQL queries for the RVVI database.
Semestral Project
Week | Lecture | Exercise |
1. | Lecture slides: Introduction, Relational data model | Tasks: SQL Basics Script: Sakila DB |
2. | Lecture slides: Relational algebra, SQL: Join Script: Student study subject | Tasks: Join Solutions: Join |
3. | Lecture slides: SQL: Aggregate functions, Group by | Tasks: Aggregate Functions and Group By Solutions: Aggregate Functions and Group By |
4. | Lecture slides: SQL: subqueries | Tasks: Set Operations and Quantifiers Solutions: Set Operations and Quantifiers |
5. | Lecture slides: Complex SQL Select Queries | Tasks: Subqueries Solutions: Subqueries |
6. | Lecture slides: Conceptual modeling | RVVI database examples |
7. | Lecture slides: Conceptual modeling, patterns, antipatterns | Test on SQL |
8. | Lecture slides: Data types, DDL, DML | Test on SQL |
9. | Lecture slides: Functional dependencies | Tasks: DML&DDL Solutions: DML&DDL |
11. | Lecture slides: Indexing | DML/DDL Test |
12. | Lecture slides: Normal Forms | Tasks: Functional Dependencies |
13. | Tasks: Normal Forms |