Introduction to Database Systems
News
- (07.12.) Lecture on 8.12. is canceled
- Third attempt of SQL Test will be on Friday 5.12.2014 at 9:00. A data model for the test remains same. The second attempt of the test from conceptual modelling will be in date.
- Test from conceptual modeling will be on Friday 21.11.2014 at 10:45 in the class EB104.
- The lecture on Monday 10.11.2014 is canceled.
- All tasks and solutions of the regular and repair tests 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.
First test, second attempt
The description of a data model that will be on the second attempt is available here (script can be found here). The second attempt will be in the class EB207 at 10:45.
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 (last change 14.9.2014) | Tasks: Sets, Relations |
| 2. | Lecture slides: Relational algebra Lecture slides: SQL I Script: Student study subject (last change 22.9.2014) | Tasks: Conceptual Data Model, SQL Script: Customer-Purchase-Product Description: Connection to a Sql Server |
| 3. | Lecture slides: SQL II (last change 3.10.2014) | Tasks: SQL I Solution: SQL I - Solution |
| 4. | Lecture slides: SQL III (last change 12.10.2014) | Tasks: SQL II Solution: SQL II - Solution |
| 5. | Lecture slides: Data types (last change 19.10.2014) | Tasks: SQL III Solution: SQL III - Solution |
| 6. | Lecture slides: Conceptual model (last change 1.11.2014) | Test 1 - SQL SELECT statement Description: Data Model Script: Person-Order-Item-Goods |
| 7. | Lecture cancelled | Practise cancelled |
| 8. | Lecture slides: JDD Lecture slides: JDM (last change: 1.11.2014) | Tasks: Conceptual modeling |
| 9. | Lecture cancelled | Tasks: Conceptual modeling, DDL |
| 10. | Lecture cancelled | Test 2 - Conceptual modeling |
| 11. | Lecture slides: Task specification Lecture slides: Functional dependencies (last change: 26.11.2014) | Approval of project topics Tasks: Functional Dependencies |
| 12. | Lecture slides: Normal forms (last change: 7.12.2014) | Tasks: Decomposition |
| 13. | Lecture cancelled | 1. presentation of the project |
| 14. | 2. presentation of the project |