460-2035/03 – Introduction to Database Systems (UDBS)

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantordoc. Ing. Radim Bača, Ph.D.Subject version guarantorIng. Radoslav Fasuga, Ph.D.
Study levelundergraduate or graduate
Study languageEnglish
Year of introduction2015/2016Year of cancellation2022/2023
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAC027 doc. Ing. Radim Bača, Ph.D.
CHO247 Ing. Peter Chovanec, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2
Part-time Graded credit 10+0

Subject aims expressed by acquired skills and competences

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.

Teaching methods

Lectures
Tutorials
Experimental work in labs

Summary

This course is a basic introduction into database technologies. The main topics are the conceptual modeling, the relational data model and the SQL language for data definition, manipulation and querying.

Compulsory literature:

* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003. * DBMS Oracle Documenation

Recommended literature:

* H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.

Additional study materials

Way of continuous check of knowledge in the course of semester

- Student have to pass two tests during the computer exercises. The first test is focused on the SQL language and the second practise database design, database schema creation and its modification. - Presentation and defense of an semestral project is based on a design of IS (conceptual model, SQL DDL sripts, SQL Select scripts)

E-learning

Other requirements

Additional requirements are placed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: - Introduction into database technologies. Motivation, data independence and RDBMS architecture. Relational data model. - Relational algebra. Basic operations. - SQL language (with focus to SQL 92), introduction of database querying using Select command. - SQL Select - inner queries - SQL Select - inner and outer join, aggregation functions and grouping. - Conceptual modeling. Entity, entity type, relation, integrity constraints, ER diagram, UML diagam. Transformation of an conceptual model to a relational data model. - SQL - data modification language (DML), data definition language (DDL). - Functional and dynamic analysis. - Functional dependencies. - Normal forms and BCNF. - Comparison of existing RDBMS. Exercises: - Relational data model. - SQL Select statement practising using a SQL Server. - Conceptual modeling using Oracle data modeler. - Conceptual modeling using Toad data modeler. - SQL JDD and JMD. - Functional dependencies. - Database design, BCNF.

Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2021/2022 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2020/2021 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2019/2020 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P English Ostrava 2 Optional study plan
2019/2020 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P English Ostrava 2 Optional study plan
2019/2020 (B2647) Information and Communication Technology (2612R059) Mobile Technology P English Ostrava 2 Optional study plan
2019/2020 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2019/2020 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K English Ostrava 2 Optional study plan
2019/2020 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K English Ostrava 2 Optional study plan
2019/2020 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K English Ostrava 2 Choice-compulsory study plan
2019/2020 (B2647) Information and Communication Technology (2612R059) Mobile Technology K English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2612R059) Mobile Technology P English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K English Ostrava 2 Choice-compulsory study plan
2018/2019 (B2647) Information and Communication Technology (2612R059) Mobile Technology K English Ostrava 2 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2017/2018 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P English Ostrava 2 Optional study plan
2017/2018 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K English Ostrava 2 Optional study plan
2017/2018 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P English Ostrava 2 Optional study plan
2017/2018 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K English Ostrava 2 Optional study plan
2017/2018 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2017/2018 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K English Ostrava 2 Choice-compulsory study plan
2017/2018 (B2647) Information and Communication Technology (2612R059) Mobile Technology P English Ostrava 2 Optional study plan
2017/2018 (B2647) Information and Communication Technology (2612R059) Mobile Technology K English Ostrava 2 Optional study plan
2016/2017 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P English Ostrava 2 Optional study plan
2016/2017 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K English Ostrava 2 Optional study plan
2016/2017 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P English Ostrava 2 Optional study plan
2016/2017 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K English Ostrava 2 Optional study plan
2016/2017 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2016/2017 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K English Ostrava 2 Choice-compulsory study plan
2016/2017 (B2647) Information and Communication Technology (2612R059) Mobile Technology P English Ostrava 2 Optional study plan
2016/2017 (B2647) Information and Communication Technology (2612R059) Mobile Technology K English Ostrava 2 Optional study plan
2015/2016 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P English Ostrava 2 Optional study plan
2015/2016 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K English Ostrava 2 Optional study plan
2015/2016 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P English Ostrava 2 Optional study plan
2015/2016 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K English Ostrava 2 Optional study plan
2015/2016 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P English Ostrava 2 Choice-compulsory study plan
2015/2016 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K English Ostrava 2 Choice-compulsory study plan
2015/2016 (B2647) Information and Communication Technology (2612R059) Mobile Technology P English Ostrava 2 Optional study plan
2015/2016 (B2647) Information and Communication Technology (2612R059) Mobile Technology K English Ostrava 2 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
V - ECTS - bc. 2019/2020 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2018/2019 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2017/2018 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2016/2017 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2015/2016 Full-time English Optional 401 - Study Office stu. block

Assessment of instruction



2019/2020 Winter
2018/2019 Winter
2017/2018 Winter
2016/2017 Winter
2015/2016 Winter