Course detail
Databases systems
FEKT-BPC-DBSAcad. year: 2024/2025
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.
Language of instruction
Czech
Number of ECTS credits
5
Mode of study
Not applicable.
Guarantor
Entry knowledge
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.
Rules for evaluation and completion of the course
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
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.
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
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.
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.
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.
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.
Study aids
Not applicable.
Prerequisites and corequisites
Not applicable.
Basic literature
Coronel, C., Morris, S. Database Systems: Design, Implementation, & Management 13th Ed. 2018
(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)
Laurenčík, Marek. SQL Podrobný průvodce uživatele. Grada Publishing, a.s., 2018. ISBN ISBN 978-80-271-0774-2 (CS)
RÁČEK, Jaroslav. Strukturovaná analýza systémů. Brno: Masarykova univerzita, 2006. ISBN 80-210-4190-0. (CS)
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)
Laurenčík, Marek. SQL Podrobný průvodce uživatele. Grada Publishing, a.s., 2018. ISBN ISBN 978-80-271-0774-2 (CS)
RÁČEK, Jaroslav. Strukturovaná analýza systémů. Brno: Masarykova univerzita, 2006. ISBN 80-210-4190-0. (CS)
RAMAKRISHNAN, Raghu a GEHRKE, Johannes. Database Management Systems. 3rd ed. New York: McGraw-Hill , 2003. ISBN 978-0-07-246563-1. (EN)
Recommended reading
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)
ŠIMŮNEK, Milan. SQL Kompletní kapesní průvodce. Praha: Grada Publishing a.s., 1998. ISBN 80-7169-692-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)
ŠIMŮNEK, Milan. SQL Kompletní kapesní průvodce. Praha: Grada Publishing a.s., 1998. ISBN 80-7169-692-7. (CS)
Classification of course in study plans
- Programme BPC-AMT Bachelor's 3 year of study, summer semester, compulsory-optional
Type of course unit
Lecture
26 hod., optionally
Teacher / Lecturer
Syllabus
Introduction, data abstraction, data models
Conceptual model, E-R diagrasms
Fundamentals of programing in Magic for windows system
Data types and operations
Batch tasks and interactive tasks
Mid-term exam passing Data integrity
Events and trigers
Transaction processing, concurrency developing
Security and data integrity
Fundamentals of database applications for Internet
HTML language and development of dynamic HTML formas, XML Technology
Data security of databases on Internet
Distributed systems, trends in database technology
Conceptual model, E-R diagrasms
Fundamentals of programing in Magic for windows system
Data types and operations
Batch tasks and interactive tasks
Mid-term exam passing Data integrity
Events and trigers
Transaction processing, concurrency developing
Security and data integrity
Fundamentals of database applications for Internet
HTML language and development of dynamic HTML formas, XML Technology
Data security of databases on Internet
Distributed systems, trends in database technology
Exercise in computer lab
26 hod., compulsory
Teacher / Lecturer
Syllabus
Introduction to Magic development tools
Type repository, Table repository, Program repository
Helprepository, Rights repository, Context menu
Batch and interractive tasks
ER diagram prototype functionalmodel
Building of Database application. Program repository
Operations, procedures and functions, project developing
Individual project developing
Transaction and locking strategy
Forms outputs
Reports, Internet forms and reports
Autorisation, DBA rights and users rights
Project presentation,
Type repository, Table repository, Program repository
Helprepository, Rights repository, Context menu
Batch and interractive tasks
ER diagram prototype functionalmodel
Building of Database application. Program repository
Operations, procedures and functions, project developing
Individual project developing
Transaction and locking strategy
Forms outputs
Reports, Internet forms and reports
Autorisation, DBA rights and users rights
Project presentation,