SubjectsSubjects(version: 945)
Course, academic year 2023/2024
   Login via CAS
Data and Process Models - NMMB303
Title: Datové a procesní modely
Guaranteed by: Department of Algebra (32-KA)
Faculty: Faculty of Mathematics and Physics
Actual: from 2021
Semester: winter
E-Credits: 5
Hours per week, examination: winter s.:2/2, C+Ex [HT]
Capacity: unlimited
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: not taught
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Guarantor: RNDr. Jiří Měska
Marian Kamenický
Václav Trojan
Class: M Bc. MMIB
M Bc. MMIB > Povinně volitelné
M Bc. MMIT > Povinně volitelné
Classification: Mathematics > Algebra
Incompatibility : NMMB334
Interchangeability : NMMB334
Is incompatible with: NMMB334
Is interchangeable with: NMMB334, NMIB008
Annotation -
Last update: G_M (16.05.2012)
Required course for bachelor's program in Information security. The course gives a basic orientation in the field of data and processing models, description of information structure and information processing and fundamentals of relation databases.
Course completion requirements -
Last update: doc. Mgr. et Mgr. Jan Žemlička, Ph.D. (28.10.2019)

Students have to pass two tests.

Literature - Czech
Last update: doc. Mgr. Petr Kaplický, Ph.D. (15.06.2015)

Martin Gruber: Mistrovství v SQL, Svazek1,2, SoftPress, 2004.

James R.Groff, Paul N.Weinberg: SQL kompletní průvodce, Computer Press, 2005.

Bruce Momjian: PostgresSQL, Praktický průvodce, Computer Press, 2003.

Thomas Kyte: Oracle návrh a tvorba aplikací, Computer Press, 2005.

Howes, T; Smith, M; Good, G: Understanding and Deploying LDAP Directory Services

Requirements to the exam -
Last update: doc. Mgr. et Mgr. Jan Žemlička, Ph.D. (28.10.2019)

Students have to pass final oral exam. The requirements for the exam correspond to what has been done during lectures and practicals.

Syllabus -
Last update: G_M (27.04.2012)

Data and their structure. Data models. E-R diagrams. Relation databases. Normalization an denormalization. Decent introduction to SQL language. Transformation of relation data schemes. Integrity of data in relation schemes. Dimensional data structures. Processing models. Processes of addition of new data and edition of current data. Time development of data. General process structures. Work-flow.

Charles University | Information system of Charles University |