Course detail

Databases systems

FEKT-BPC-DBSAcad. year: 2019/2020

The course deals with the issue of architecture of RDBMS, a background of data and system analysis. The emphases are put on normalization-based design of relational database and transaction processing languages.

Learning outcomes of the course unit

Students are able to develop conceptual models of an application for relational database in client/server and internet environment. Students have basic knowledge of database management system fundamentals.

Prerequisites

The subject knowledges on the secondary school level and at the level of the 2nd year Bachelor studies are required. Students should also have such language skills to understand educational materials in English.

Co-requisites

Not applicable.

Recommended optional programme components

Not applicable.

Recommended or required reading

RAMAKRISHNAN, Raghu a GEHRKE, Johannes. Database Management Systems. 3rd ed. New York: McGraw-Hill , 2003. ISBN 978-0-07-246563-1. (EN)
Korth H.F, Silberschatz,A.:Database System Concepts,McGRAW-HILL. 1996 (EN)
KRÁL, Jaroslav. Informační systémy. Veletiny: Science, 1998. 356 pp. ISBN 80-86083-00-4. (CS)
HERNANDEZ, Michael J. Návrh databází. Přeložil Jan Bouda. Praha: GradaPublishing a.s., 2005. ISBN: 80-247-0900-7. (CS)
Hernandez, Michael J. Návrh databází. Přeložil Jan Bouda 1. vyd. Praha :GradaPublishing a.s.2006 (CS)
Kofler, Michael. Mistrovství v MySQL 5 : Kompletní průvodce webového vývojáře. Computer Press, 2007 ISBN 978-80-251-1502-2 (CS)
Laurenčík, Marek. SQL Podrobný průvodce uživatele. Grada Publishing, a.s., 2018. ISBN ISBN 978-80-271-0774-2 (CS)
ŠIMŮNEK, Milan. SQL Kompletní kapesní průvodce. Praha: Grada Publishing a.s., 1998. ISBN 80-7169-692-7. (CS)
Ráček, J.: Strukturovaná analýza systémů, Masarykova univerzita, ISBN 80-210-4190-0 (CS)
RÁČEK, Jaroslav. Strukturovaná analýza systémů. Brno: Masarykova univerzita, 2006. ISBN 80-210-4190-0. (CS)

Planned learning activities and teaching methods

Teaching methods include lectures, computer laboratories. Students have to write a single project of IS in any BDMS.

Assesment methods and criteria linked to learning outcomes

Finally project with basic properties:
Data integrity, output forms with simple and cumulative items, different roles for application users and administrators.

Up to 30 points for project evaluation
Up to 70 points for the final oral examination

Language of instruction

Czech

Work placements

Not applicable.

Course curriculum

1. Basic relational database terms. Basic data types.
2. Relational model. Entity, attribute, cardinality, index, primary key, foreign key.
3. Database normalization, functional dependency.
4. Logical and physical model. ERD, data flow diagram, ELH.
5. Functional model, data flow diagram.
6. Design of forms.
7. SQL language for data manipulation and definition.
8. Database security, roles, users.
9. Database transaction.
10. Data integration.
11. Client server architecture, thin client, fat Client, differences.
12. Internet applications, xml technology.
13. Web services.

Aims

The aims are to present mastering fundamentals of design and development database applications; to manage mastering fundamentals of relational database theory and skill in using database technology at a level required for database design, development of database applications for multiuser and internet access and database administration.

Specification of controlled education, way of implementation and compensation for absences

The content and forms of instruction in the evaluated course are specified by a regulation issued by the lecturer responsible for the course and updated for every academic year.

Classification of course in study plans

  • Programme BPC-AMT Bachelor's, 3. year of study, summer semester, 5 credits, compulsory-optional

  • Programme EEKR-CZV lifelong learning

    branch ET-CZV , 1. year of study, summer semester, 5 credits, compulsory-optional

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Computer exercise

26 hours, compulsory

Teacher / Lecturer

eLearning