- Course unit code:
- N422I1_4I
- Course unit title:
- Information Technology I
- Mode of completion and Number of ECTS credits:
- Class req (2 credits)
- Course supervisor:
- prof. Ing. Miroslav Fikar, DrSc.
- Name of lecturer(s):
- J. Holaza (2023/2024 – Winter)
J. Holaza (2022/2023 – Winter)
D. Dzurková (2021/2022 – Winter)
M. Mojto (2020/2021 – Winter)
M. Mojto (2019/2020 – Winter)
Ľ. Čirka (2018/2019 – Winter)
Ľ. Čirka (2017/2018 – Winter)
Ľ. Čirka (2016/2017 – Winter)
Ľ. Čirka (2015/2016 – Winter) - Learning outcomes of the course unit:
- Students know fundamentals of creating and using of databases in Microsoft Access. They are able to design and create basic database objects (tables, forms, quaries, and reports). Students have learned basic SQL statements for creating queries. They have knowledge of the principles of database normalization.
- Prerequisites for registration:
- none
- Course contents:
- Introduction to relational databases
Database system MS Access - overview of IDE
Database normalization (normal forms - 1NF, 2NF, 3NF)
Table creation (fields, data types, indexes, field properties, update)
Relations and reference integrity
Techniques for databases (E-R model)
Forms and their elements
Forms and their data
Queries
SQL language I
SQL language II
Reports
Practical application using AIS database - Recommended or required reading:
- Basic:
- MATÚŠ, Z. Access v příkladech. ČR: Computer Media, 2006. 128 s. ISBN 80-86686-55-8.
- ŠEDOVÁ, H. Access 2007 nejen pro školy. ČR: Computer Media, 2010. 192 s. ISBN 978-80-7402-038-4.
- MACDONALD, M. Access 2007: The Missing Manual. 1005 Gravenstein Higway North, Sebastopol, CA 95472: O'Reilly Media, 2006. 752 s. ISBN 978-0-596-52760-0.
- CHURCHER, C. Beginning Database Design: From Novice to Professional. New York: Apress, 2012. 252 s. ISBN 978-1-4302-4209-3.
- Planned learning activities and teaching methods:
- The course Information Technologies I contains 13 seminars, each taking 2 hours.
- Assesment methods and criteria:
- individual work
- Language of instruction:
- Slovak, English
Institute of Information Engineering, Automation and Mathematics was established in 1.1.2006 from two departments: Department of Information Engineering and Process Control and Department of Mathematics.
Latest Posts
- Open access to our new research article15.4.2024 10:33
- Workshop Want-ed11.4.2024 17:10
- FrontSeat Newsletter vol.310.4.2024 9:53
Contact
Radlinského 9
812 37 Bratislava, Slovakia
Tel.: +421 259 325 366
Fax: +421 259 325 340
Mobil: +421 918 674 366
e-mail: office@uiam.sk
6th floor, Block C NB
2024 © All Rights Reserved. UIAM FCHPT STU | webmaster@uiam.sk