Course syllabus 482E401 - Database Systems (FEM - SS 2018/2019)

     Information sheet          Detailed content          Timetable          ECTS syllabus          

     Slovak          English          

University: Slovak University of Agriculture in Nitra
Faculty: Faculty of Economics and Management
Course unit code: 482E401
Course unit title: Database Systems
Planned types, learning activities and teaching methods:
lecture1 hour weekly / 5 hours per semester of study (on-site method)
seminar3 hours weekly / 15 hours per semester of study (on-site method)

Credits: 6
Semester: -- item not defined --
Level of study: 2.
Prerequisites for registration: none
Assesment methods :
Active participation in seminars, successful management of sub-tasks assigned during the semester, development and advocacy project, successful completion of the final test
Learning outcomes of the course unit:
After completion of the subject the student will understand the problematics of database designing and will be able to apply appropriations of data processing means that support SQL language standard - mainly an MS Access application. In practice, the issue is focused on the relational data models, database designing and their optimization. Student become familiar with the rules, syntax and principles of work with queries designing and other objects like forms and reports. Part of the subject is an introduction to work with macros in MS Access.
Course contents:
1.Basic terminology and principles of database processing. Data abstraction layers. Physical and logical data independence.
2.Data models, their characteristics and uses to describe database systems.
3.Properties, characteristics and principles of relational databases. Designing and modeling of databases in Microsoft Access.
4.Components of conceptual, logical and physical design of database.
5.Query languages SQL and QBE, basic features, commands and clauses. History of SQL.
6.The logical design of database systems and normalization.
7.The physical design of database systems.
Recommended or required reading:
Basic:
ZÁHOREC, J. -- HALLOVÁ, M. Databázové systémy: tvorba a aplikácie relačných databáz. 1st ed. Nitra : Slovenská poľnohospodárska univerzita, 2013. 162 p. ISBN 978-80-552-1118-3.

Recommended:
DELIKÁT, T.: Základy databázových systémov. Bratislava, 2006, ISBN 80-969484-4-X, 210 s.
DRLÍK, M - SKALKA, J.: Tvorba databáz v prostredí MS Access. Prírodovedec č. 284, UKF v Nitre, 2007, 130s
ŽABKA,J. - KOČÍKOVÁ,E.: Charakteristiky databázových systémov. TnU Trenčín 2001.

Language of instruction: Slovak
Notes:
Evaluation of course unit:
Assessed students in total: 415

ABCDEFX
42,9 %12,3 %24,6 %8,7 %10,8 %0,7 %
Name of lecturer(s): Ing. Marcela Hallová, PhD. (examiner, instructor, lecturer)
doc. PaedDr. Peter Polakovič, Ph.D. (lecturer)
doc. Ing. Vladimír Popelka, CSc. (person responsible for course)
Last modification: 5. 3. 2019
Supervisor: doc. Ing. Vladimír Popelka, CSc. and programme supervisor


Last modification made by Iveta Kunová on 03/05/2019.

Type of output: