Oct 16, 2019   9:31 p.m. Vladimíra
Academic information system

Course syllabus N422I1_4I - Information Technology I (FCFT - WS 2015/2016)


     Information sheet          ECTS          Syllabus          


     Slovak          English          


University: Slovak University of Technology in Bratislava
Faculty: Faculty of Chemical and Food Technology
Course unit code: N422I1_4I
Course unit title: Information Technology I
Mode of delivery, planned learning activities and teaching methods:
laboratory/construction practice2 hours weekly (on-site method)

 
Credits allocated: 2
 
Recommended semester/trimester: Control of Technological Processes in Chemical and Food Industries - master (compulsory), 1. semester
Chemical Engineering - master (optional), 1. semester
Level of study: 2.
Prerequisites for registration: none
 
Assesment methods:
Students will write 2 quizzes during the semester. The sum of points for the quizzes is 100. Students will successfully pass the quizzes if they earn at least 56 points. Students are graded as follows: A 92–100 points, B 83–91 points, C 74–82 points, D 65–73 points, E 56–64 points.
 
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.
 
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 p. ISBN 80-86686-55-8.
ŠEDOVÁ, H. Access 2007 nejen pro školy. ČR: Computer Media, 2010. 192 p. 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 p. ISBN 978-0-596-52760-0.
CHURCHER, C. Beginning Database Design: From Novice to Professional. New York: Apress, 2012. 252 p. ISBN 978-1-4302-4209-3.

 
Language of instruction: slovak or english
 
Notes:
 
Courses evaluation:
Assessed students in total: 81

ABCDEFX
44,4 %30,9 %13,6 %6,2 %4,9 %0 %
Name of lecturer(s): Ing. Ľuboš Čirka, PhD. (instructor) - slovak, english
prof. Ing. Miroslav Fikar, DrSc. (examiner, lecturer, person responsible for course) - slovak, english
 
Last modification: 14. 12. 2015
Supervisor: prof. Ing. Miroslav Fikar, DrSc. and programme supervisor


Last modification made by Ing. Tomáš Molnár on 12/14/2015.

Type of output: