460-2056/02 – Database Systems I (DS I)

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantordoc. Ing. Radim Bača, Ph.D.Subject version guarantordoc. Ing. Radim Bača, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory type A
Year3Semesterwinter
Study languageEnglish
Year of introduction2019/2020Year of cancellation
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.
KRA28 prof. Ing. Michal Krátký, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2

Subject aims expressed by acquired skills and competences

The primary 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 general knowledge of the basic SQL commands according to the SQL92 standard.

Teaching methods

Lectures
Tutorials
Project work

Summary

This course is a basic introduction to 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:

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

Recommended literature:

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

Way of continuous check of knowledge in the course of semester

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

E-learning

Other requirements

There are no additional requirements are placed on a student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Lectures: - Introduction to database technologies. Motivation, data independence, and RDBMS architecture. Relational data model. - Relational algebra. Basic operations. - SQL language (with a focus to SQL 92), an 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 diagram. Transformation of a 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 practices. SQL Server is used to evaluate the language. - 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

Full-time form (validity from: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded credit Graded credit 100 (100) 51 3
        SQL Select Written test 40  20
        SQL DDL and DML Written test 20  10
        Database design Project 30  15
        Final test Written test 10  5
Mandatory attendence participation: Students have to pass every test/project in the subject.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Completion of all mandatory tasks within individually agreed deadlines.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0613A140010) Computer Science INF P English Ostrava 2 Compulsory study plan
2024/2025 (B0714A060017) Biomedical Technology P English Ostrava 2 Optional study plan
2024/2025 (B0714A060019) Biomedical Assistive Technology EaI P English Ostrava 3 Compulsory study plan
2023/2024 (B0613A140010) Computer Science INF P English Ostrava 2 Compulsory study plan
2023/2024 (B0714A060017) Biomedical Technology P English Ostrava 2 Optional study plan
2023/2024 (B0714A060019) Biomedical Assistive Technology EaI P English Ostrava 3 Compulsory study plan
2023/2024 (B0541A170009) Computational and Applied Mathematics P English Ostrava 3 Optional study plan
2022/2023 (B0613A140010) Computer Science INF P English Ostrava 2 Compulsory study plan
2022/2023 (B0714A060017) Biomedical Technology P English Ostrava 2 Optional study plan
2022/2023 (B0714A060019) Biomedical Assistive Technology EaI P English Ostrava 3 Compulsory study plan
2022/2023 (B0541A170009) Computational and Applied Mathematics P English Ostrava 3 Optional study plan
2021/2022 (B0613A140010) Computer Science INF P English Ostrava 2 Compulsory study plan
2021/2022 (B0714A060017) Biomedical Technology P English Ostrava 2 Optional study plan
2021/2022 (B0714A060019) Biomedical Assistive Technology EaI P English Ostrava 3 Compulsory study plan
2021/2022 (B0541A170009) Computational and Applied Mathematics P English Ostrava 3 Optional study plan
2020/2021 (B0714A060017) Biomedical Technology P English Ostrava 2 Optional study plan
2020/2021 (B0714A060019) Biomedical Assistive Technology EaI P English Ostrava 3 Compulsory study plan
2020/2021 (B0613A140010) Computer Science INF P English Ostrava 2 Compulsory study plan
2020/2021 (B0714A060011) Telecommunication Technology KB P English Ostrava 3 Choice-compulsory type A study plan
2020/2021 (B0541A170009) Computational and Applied Mathematics P English Ostrava 3 Optional study plan
2019/2020 (B0714A060011) Telecommunication Technology KB P English Ostrava 3 Choice-compulsory type A study plan
2019/2020 (B0613A140010) Computer Science INF P English Ostrava 2 Compulsory study plan
2019/2020 (B0541A170009) Computational and Applied Mathematics P English Ostrava 3 Optional study plan
2019/2020 (B0714A060017) Biomedical Technology P English Ostrava 2 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
V - ECTS - bc. (nezveřejňovat) 2023/2024 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2023/2024 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2022/2023 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2021/2022 Full-time English Optional 401 - Study Office stu. block
V - ECTS - bc. 2020/2021 Full-time English Optional 401 - Study Office stu. block

Assessment of instruction



2023/2024 Winter