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                           Solutions: SQL Basics  Script: Sakila DB                           Description: Connection to a Sql Server
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
10.	Lecture slides: Normal forms	DML/DDL Test
11.	Lecture slides: Database systems review	Database design
13.		Tasks: Functional Dependencies, Normal Forms