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.
Project
Instruction can be found here.
The first test (SQL language) will be in 6th week (22.10.2012) !!!
The solution of the first test is presented here.
The second test (Conceptual modelling) will be in 9th week (12.11.2012) !!!
The repair test (SQL language) will be in 10th week (23.11.2012) !!! The test model is presented here and script here.
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | Lecture slides: Introduction to database systems Lecture slides: Relational model Lecture slides: Relational algebra last change: 17.9.2012) | - |
| 2. | Lecture slides: SQL - SELECT Scripts for a lecture: here (last change: 26.9.2012) | Connection to a SQL Server (last change: 24.9.2012) |
| 3. | Lecture slides: SQL - SELECT Lecture slides: SQL - DML (last change: 1.10.2012) | Tasks: SQL - SELECT Script: User Product Purchase Solutions: Solutions |
| 4. | Lecture slides: Conceptual modeling (last change: 8.10.2012) | Tasks: SQL - SELECT II Solutions: Solutions |
| 5. | Lecture slides: SQL - DDL (last change: 20.10.2012) | Consultation |
| 6. | - | SQL Test Description: Example Test - Description Tasks: Example Test - Tasks Script: User Product Purchase Complaint |
| 7. | Lecture slides: IS design (last change: 5.11.2012) | Tasks: Conceptual modeling (last change: 26.10.2012) |
| 8. | - | Tasks: Conceptual modeling (last change: 5.11.2012) |
| 9. | Lecture slides: Functional dependencies (last change: 12.11.2012) | Test - Conceptual Modelling |
| 10. | Lecture slides: BCNF (last change: 2.12.2012) | Tasks: Functional Dependencies (last change: 19.11.2012) |
| 11. | Lecture was canceled | Tasks: Decomposition (last change: 24.11.2012) |
| 12. | Lecture slides: 3NF (last change: 2.12.2012) | First presentation of the project |
| 13. | - | Second presentation of the project |
| 14. | Lecture slides: Summary, IS architectures, Database types | - |