Information Systems in Transportation

Course guarantor:

Marek Kalika

Lecturer:

Marek Kalika, Jana Kaliková, Jan Krčál

Tutor:

Marek Kalika, Jana Kaliková, Jan Krčál

Supervisor:

Department of Applied Informatics in Transportation

Synopsis:

Architecture and cloud services concept, eGovernment-structure. Electronic communication and signature. IS life cycle and IT projects. Types of information systems and specific implementation in transport. Roles, processes, management, optimization in IS. Oracle data types. SQL Developer, SQL queries. Comprehensive example and web application programming.

Requirements:

basic knowledge of relational database systems

Syllabus of lectures:

Syllabus of tutorials:

1. Relational databases - normal forms, modelling relationships

2. Data integrity, relational algebra

3. Oracle data types

4.-.5. Working with the SQL Developer development environment

6.- 10. SQL queries

11.-13. Sample Example 1

14.-15. Example 2

16.-20. Programming a Web Application

Study Objective:

Obtain a comprehensive overview of information system. Acquire a basic knowledge of creating information systems based on database technologies. Understand and utilize knowledge in the development of communication part of the system of portal technology, the basic rules for the user interface.

Study materials:

Jeřábek M., a kol.: Databázové systémy pro dopravní aplikace, vydavatelství ČVUT, 2010

Moos P., Malinovský V.: Informační systémy a technologie, Praha, 2006, ČVUT-ČAV McLeod, R.: Management Information Systems, ISBN 0-13-8961

Starks, J.L., Pratt, P.J., Last, M.Z.: Concepts of Database Management,Cengage Learning 2018,ISBN 978-1337093422

Note:

Time-table for winter semester 2024/2025:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue	roomHO:A-270 Kaliková J. Krčál J. 09:45–14:45 (parallel nr.321) Horská 3 (stará budova)
Wed	roomHO:A-270 Kaliková J. Krčál J. 09:45–14:45 (parallel nr.321) Horská 3 (stará budova)
Thu	roomHO:B-302 Kaliková J. Krčál J. 13:15–18:15 (parallel nr.321) Horská 3 (nová budova)
Fri

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Bachelor TET-ITS Full-Time from 2022/23 (compulsory course)
• Bachelor TET-ITS Full-Time from 2023/24 (compulsory course)