Database Systems I

Test on SQL

The conceptual model of each project must include at least five entity types and five relationships. The maximum number of tables in the resulting relational model is ten. The optimal number is considered to be approximately seven tables.
The project consists of the following parts:
- Data models (due within two days after the 11th seminar) (25 points / minimum 10 points)
- Presentation of the data model (online during week 13) (5 points)
The data analysis will include:
- A graphical form of the conceptual model. (this part is optional)
- A graphical form of the relational data model.
- For each table, clearly describe what a single record in that table represents.
- The submission must also include generated DDL and DML scripts.
Final project presentation will last approximately 3 to 5 minutes (3 minutes for the student's presentation and the remaining time for questions).

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 Task: Task
13.		Tasks: Functional Dependencies, Normal Forms