| Course Unit Code | Course Unit Title | Number of ECTS Credits Allocated |
|---|
| 460-2035/01 | Introduction to Database Systems | 6 ECTS credits |
| Type of Course Unit | Choice-compulsory |
|---|
| Level of Course Unit | First Cycle |
|---|
| Year of Study | Second Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech, English |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| BAC027 | Ing. Radim Bača, Ph.D. |
| CHO247 | Ing. Peter Chovanec |
| Learning Outcomes of the Course Unit |
|---|
Main goal is to introduce the basic database concepts such as the relational model and the SQL language. The students
who finish this course will be able to specify the conceptual model and the relational scheme of an information
system and they will have a deep knowledge about the basic SQL commands according to the SQL92 standard. |
| Recommended Optional Programme Components |
|---|
| Common optional components are not offered, students of special interest can participate in departmental activities or can arrange consulting hours with lecturer. |
| Course Contents |
|---|
Lectures:
- Introduction into database technologies.
- Conceptual modeling. Entity, entity type, relation, integrity constraints, ER diagram, UML diagam
- Relational data model. Relation, relational scheme, relational database.
- Relational algebra. Basic operations.
- SQL language (with focus to SQL 92)
- SQL - DDL, DML, data types.
- SQL - příkaz SELECT.
- SQL - join operation, efficiency of a query processing.
- Transformation of an conceptual model to a relational data model.
- Functional dependencies.
- Normal forms and BCNF.
- Functional and dynamic analysis.
Exercises:
- Introduction into a ER modeling tool.
- Creation of ER models using the ER modeling tool.
- Introduction into a DBMS interfaces.
- SQL - DDL.
- SQL - DML.
- SQL - SELECT command.
- SQL processing efficiency
- Transformation of an conceptual model to a relational data model.
- Database design, BCNF.
- Functional and dynamic analysis. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* DBMS Oracle Documenation |
* J. Pokorný, I. Halaška: Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 2003. 148 s. ISBN 80-01-02789-9.
* J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
* J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992
* H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* Dokumentace k SŘBD Oracle |
| Recommended Reading: |
|---|
| * H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001. |
* M. Krátký, R. Bača: Databázové systémy. http://db.cs.vsb.cz/edu/dbsys.pdf. leden, 2009.
* J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
* J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992 |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Experimental work in labs |
| Assesment methods and criteria |
|---|
| Tasks are not Defined |
| Work placement(s) |
|---|
| Course does not contain work placement. |
