460-2044/03 – Technology Database Systems I (TDS I)

Gurantor departmentDepartment of Computer ScienceCredits2
Subject guarantorIng. Radoslav Fasuga, Ph.D.Subject version guarantorIng. Radoslav Fasuga, Ph.D.
Study levelundergraduate or graduateRequirementOptional
Year2Semestersummer
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FAS01 Ing. Radoslav Fasuga, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+0
Part-time Graded credit 10+0

Subject aims expressed by acquired skills and competences

The aim of the course is to increse students' knowledge for the course UDBS in conceptual modeling, database design and query language SQL. The course is focused on the Oracle DBMS. For successful completion of the course students must to complete two partial and two final tests and submit semestral project on a selected topic which incluzdes a conceptual model, relationship, the SQL commands for creating and working with this model over the full course.

Teaching methods

Lectures
Project work

Summary

Course target is to increase knowledge of database courses with English terminology and their practical use in range of Oracle company products.

Compulsory literature:

E-learnig Course - OracleAcademy Database Design - Student E-learnig Course - OracleAcademyDatabaseProgrammingwith SQL - Student http://academy.oracle.com

Recommended literature:

List of Presentations, Sylabus, and Tasks for solving. Available on MS Teams.

Way of continuous check of knowledge in the course of semester

On-line testing.

E-learning

Study in LMS Oracle.

Other requirements

Complete all tests and semestral project. Complete all tests for 60% minimal score, and success defense of semester project.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Course content: 1. database design, ERD. 2. ERD. 3. Convert from conceptual to database model. 4. Introduction into SQL, SELECT. 5. Function, relationships. 6. Construction of GROUP BY, subquery, proprietary relationships in DBMS Oracle. 7. DML (Data Manipulatin Language). 8. DDL (Data Definition Languade). 9. Creating and working with view. 10. Creating and managing Constraints. 11. Introduction into database security. 12. Transactions. 13. Query quality evaluation.

Conditions for subject completion

Part-time form (validity from: 2019/2020 Summer 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
        Test Midterm 1 Written test 10  6 3
        Test Final 1 Written test 10  6 3
        Test Midterm 2 Written test 10  6 3
        Test Final 2 Written test 10  6 3
        Project Project 60  27 3
Mandatory attendence participation: Participation in exercises is mandatory and is controlled. The course guarantor will inform students of the scope of compulsory participation at the beginning of the semester.

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 (B0613A140014) Computer Science P Czech Ostrava 2 Optional study plan
2024/2025 (B0613A140014) Computer Science K Czech Ostrava 2 Optional study plan
2023/2024 (B0613A140014) Computer Science K Czech Ostrava 2 Optional study plan
2023/2024 (B0613A140014) Computer Science P Czech Ostrava 2 Optional study plan
2022/2023 (B0613A140014) Computer Science K Czech Ostrava 2 Optional study plan
2022/2023 (B0613A140014) Computer Science P Czech Ostrava 2 Optional study plan
2022/2023 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 2 Optional study plan
2022/2023 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 2 Optional study plan
2021/2022 (B0613A140014) Computer Science P Czech Ostrava 2 Optional study plan
2021/2022 (B0613A140014) Computer Science K Czech Ostrava 2 Optional study plan
2021/2022 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 2 Optional study plan
2021/2022 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 2 Optional study plan
2020/2021 (B0613A140014) Computer Science K Czech Ostrava 2 Optional study plan
2020/2021 (B0613A140014) Computer Science P Czech Ostrava 2 Optional study plan
2020/2021 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 2 Optional study plan
2020/2021 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 2 Optional study plan
2019/2020 (B0613A140014) Computer Science P Czech Ostrava 2 Optional study plan
2019/2020 (B0613A140014) Computer Science K Czech Ostrava 2 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2022/2023 Summer
2021/2022 Summer
2020/2021 Summer