Introduction to Database Systems
Credit conditions
You have to pass two tests which will take place directly on a computer during an excercise. The first test will be focused on a SELECT queries. The second test will be focused on database design and its creation. It will be possible to use any materials (of course any communication with coleques will be prohibited) . Minimimal number of points per test is 7 and maximal 15. At most two attempts of every test will be possible.
Another part of the credit is a home project which is focused on a analysis of an information system.
First test
Here you can find tasks for practising SQL queries.
Second attempt of the first test
The second posibility to pass the test will be 22.11.2013, 9:00 at E320. Here you can find the data model description and script.
Project
Here you can find the description related to the project.
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | Lecture slides: Introduction to database systems Lecture slides: Relational model last change 16.9.2013 | Tasks: Relations sets |
| 2. | Lecture slides: Relational algebra Lecture slides: SQL I Script: Student study subject last change 25.9.2013 | Tasks: Data models |
| 3. | Lecture slides: SQL II last change 3.10.2013 | Tasks: SQL I Solution: SQL I - Solution Script: User brouth product Description: Connection to a Sql Server |
| 4. | Lecture slides: SQL III | Tasks: SQL II Solution: SQL II - Solution |
| 5. | Tasks: SQL III Solution: SQL III - Solution | |
| 6. | Test1, first attempt Data model: Model description Script: SQL script | |
| 7. | Lecture slides: Conceptual modeling | Tasks: Conceptual modeling |
| 8. | Lecture slides: DDL Lecture slides: DML | Tasks: Conceptual modeling |
| 9. | Lecture slides: IS design | Test2, first attempt |
| 10. | Lecture slides: Functional dependencies | Tasks: Functional dependencies |
| 11. | Lecture slides: Normal forms | Tasks: Decomposition |
| 12. | Final test: Examples of questions |