Introduction to Database Systems
News
- (25.01.) Another possibility to pass the final exam is 27.1. at 10:45 in EB213. You do not have to register, just come.
- (27.11.) The second repair test from SQL language will be on 8.12 at 12:30 in class EB113.
- (24.11.) All tasks and solutions of the repair test from SQL language are presented here.
- (23.11.) The repair test from conceptual modeling will be on 1.12. at 12:30 in class EB113.
- (28.10.) All tasks and solutions of the regular test from SQL language are presented here.
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 a 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 modeling test is 20 and minimum 10. 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. The maximum number of points for the home project is 30 and minimum is 15.
Project
Here you can find the thorough description related to the project.
Software
Students can use following software for conceptual modeling: Oracle data modeler and Toad data modeler. Toad data modeler is currently available only as a trial version, but students can register on the product website and get the 6-month licence.
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | Lecture slides: Introduction to database systems Lecture slides: Relational model | Tasks: Sets, Relations |
| 2. | Lecture slides: Relational algebra Lecture slides: SQL I Script: Student study subject | Tasks: Conceptual Data Model, SQL Script: Customer-Purchase-Product Description: Connection to a Sql Server |
| 3. | Lecture slides: SQL II | Tasks: SQL I Solution: SQL I |
| 4. | Lecture slides: SQL III | Tasks: SQL II Solution: SQL II |
| 5. | Skript: Sample tasks | Tasks: SQL III Solution: SQL III |
| 6. | Lecture slides: Conceptual modeling | Test 1 - SQL SELECT statement Description: Data Model Script: Person-Event-Device |
| 7. | Lecture cancelled | Tasks: Conceptual modeling |
| 8. | Lecture slides: Conceptual modeling ,JDD, JDM | Tasks: Conceptual modeling II, DDL |
| 9. | Lecture cancelled | Test 2 - Conceptual modelling |
| 10. | Lecture cancelled | Specification of the project |
| 11. | Lecture slides: Task specification Lecture slides: Functional dependencies | Approval of project topics Tasks: Functional Dependencies |
| 12. | Lecture slides: Normal forms | Tasks: Decomposition |
| 13. | Lecture slides: Comparison of databases | 1. presentation of the project |
| 14. | Final test (max 10p/ min 5p) | 2. presentation of the project |