Introduction to Database Systems
News
- (12.12.) You can try to pass the final test again on friday 16.12. 12:30 at NK418.
- (14.11.) The project decription is now available (week 10)
- (03.11.) The SQL test together with the solutions is available here.
- (16.10.) The description of the data model, the corresponding DDL script for the test as well as example test tasks are available now!
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.
Lectures and Exercises
-->
| Week | Lecture | Exercise |
| 1. | Lecture slides: Introduction to database systems Lecture slides: Relational model | Tasks: Conceptual Data Model, SQL Script: Customer-Purchase-Product Description: Connection to a Sql Server |
| 2. | Lecture slides: Relational algebra Lecture slides: SQL I Script: Student study subject | Tasks: Task understanding |
| 3. | Lecture slides: SQL II | Excercise canceled |
| 4. | Lecture slides: SQL III | Tasks: SQL I Solution: SQL I |
| 5. | Lecture slides: Conceptual modeling I | Tasks: SQL II Solution: SQL II |
| 6. | Script: Test examples | Examples of test tasks |
| 7. | Lecture slides: Conceptual modeling II | Test 1 - SQL SELECT statement Description: Data Model Script: Product-Customer-Purchase-Complaint |
| 8. | Lecture slides: JDD | Conceptual modeling using CASE tools |
| 9. | Lecture slides: JDM | Tasks: Conceptual Modelling, DDL |
| 10. | Specification: Project | Test 2 - Conceptual modelling |
| 11. | Lecture slides: Task specification Lecture slides: Functional dependencies | Approval of project topics Submission of task specification (27.11.) |
| 12. | Lecture slides: Normal forms | Tasks: Functional Dependencies Submission of conceptual model (4.12.) |
| 13. | Lecture slides: Comparison of databases Lecture canceled | Tasks: Decomposition Submission of SQL Scripts (11.12.) |
| 14. | Final test (max 10p/ min 5p) | Presentation of the project and final submission of project |