456-0526/02 – Data Processing Theory (TZD)

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantordoc. Ing. Radim Bača, Ph.D.Subject version guarantordoc. Ing. Radim Bača, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2009/2010Year of cancellation2009/2010
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
DRA108 Ing. Tomáš Drábek
FAS01 Ing. Radoslav Fasuga, Ph.D.
FIL130 Ing. Zdeněk Filipec
JUC017 Ing. Veronika Jůchová
NAV79 Ing. Lumír Návrat
S1E52 Ing. Emilie Šeptáková
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 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. * Oracle DBMS documentation

Recommended literature:

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

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. - Presentation and defense of an semestral project is based on a design of IS (conceptual model, data model, SQL scripts)

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

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.

Conditions for subject completion

Full-time form (validity from: 2009/2010 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (55) 51
        Exercises evaluation Credit  (45)
                SQL knowledge test Laboratory work 15  7
                Database design knowledge test Laboratory work 15  7
                Information system design Semestral project 15  7
        Examination Examination 55 (55) 28
                Written examination Written examination 55  28
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2009/2010 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (55) 51
        Exercises evaluation Credit  (45)
                SQL knowledge test Laboratory work 15  7
                Database design knowledge test Laboratory work 15  7
                Information system design Semestral project 15  7
        Examination Examination 55 (55) 28
                Written examination Written examination 55  28
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2009/2010 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R059) Mobile Technology P Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 2 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R059) Mobile Technology K Czech Ostrava 2 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner