Database Systems I

Important

• The subject is finished and all points are in IS Edison. Contact the lecturer in the case of any problems with the evaluation in the subject.

Summary of main documents

• Project description (updated 3.11. - we have postponed the data model deadline)
• Sample project
• Description of the test data model (in week 7)
• DDL script for the test 1
• Test 1 with the solutions
• Examples of questions for the final test

Credit Conditions

You have to pass two tests which will take place directly on a computer during an exercise. The first test will be focused on SELECT queries. The second test will be focused on a database conceptual design and its creation. It is possible to use any materials during the tests (any communication with classmates will be prohibited). The maximum number of points for the SELECT test is 40 and minimum 20. The maximum number of points for the conceptual modelling test is 20 and minimum 10. At most two attempts of every test will be possible.  

The First Test

The first test will take place on the exercise no. 7. Students are allowed to use any static materials available on the web. They are not allowed to access shared content (email, social networks, forums, online documents and so on).

Home Project

Another part of the credit is a home project which is focused on data analysis of an information system. The maximum number of points for the home project is 30 and the minimum is 15. The detailed description of the project can be found here and example of the data analysis can be found here

Before you will upload your SQL scripts into the system, you may test them using the desktop application. We will use this software for the evaluation as well. The link also contains a template of the SQL scripts with the three files. 

Week	Lecture	Exercise
1.	Lecture slides: Introduction to database systems	Tasks: SQL Basics Solutions: SQL Basics Script: Sakila DB Description: Connection to a Sql Server
2.	Lecture slides: Relational algebra + SQL I      Script: Student study subject	Tasks: Join Solutions: Join
3.	Lecture slides: SQL II	Tasks: Aggregate Functions and Group By Solutions: Aggregate Functions and Group By
4.	Lecture slides: SQL III	Tasks: Set Operations and Quantifiers Solutions: Set Operations and Quantifiers
5.	Lecture slides: SQL IV	Tasks: Subqueries Solutions: Subqueries
6.	Lecture slides: Task Specification & Conceptual Modeling
7.	Holidays
8.	Lecture slides: Conceptual Modeling II	Test 1
9.	Lecture slides: DML & DDL commands	Tasks: DML&DDL Solutions: DML&DDL
10.	Lecture cancelled	Test 2
11.	Lecture slides: Functional Dependencies
12.	Lecture slides: Normal forms	Tasks: Functional dependencies
13.	Lecture slides: Indexing	Tasks: Normal functions
14.	Examples of questions for the final test