Course syllabus E15-0053-I - Database Systems (FEM - WS 2019/2020)

     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: E15-0053-I
Course unit title: Database Systems
Planned types, learning activities and teaching methods:
lecture2 hours weekly (on-site method)
seminar2 hours weekly (on-site method)

Credits: 6
Semester: Quantitative Methods in Economics - master (required), 1. semester
Level of study: 2.
Prerequisites for registration: none
Assesment methods :
During the the semester will be one credit test for 30 points and a final written exam for 50 points. On completion of the course is necessary to draw up and successfully defend a semester project for 20 points. To the total score is counted active participation on seminars and successfully manage sub-tasks assigned during the semester. To obtain the evaluation A is needed to gain at least 93 points, for B is needed to gain at least 86 points, for C is needed to gain at least 79 points, for D is needed to gain at least 72 points and for E is needed to gain at least 64 points.
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 in database application MS Access and acquire knowledge of programming language VBA for this application. In practice, the issue is focused on the relational data models, database designing and their optimization.
Course contents:
Basic terminology and principles of database processing. Physical and logical data independence. Data models, their characteristics and uses to describe database systems. Properties, characteristics and principles of relational databases. Designing and modeling of databases in Microsoft Access. Tables, forms, queries, reports and macros. Components of conceptual, logical and physical design of database.
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:
BERKA, P.: Dobývání znalostí z databází. Praha : Academia, 2003, ISBN 80-200-1062-9
DELIKÁT, T.: Základy databázových systémov. Bratislava, 2006, ISBN 80-969484-4-X, 210 s.
KRUCZEK A.: Access 2007 - podrobná užívateľská príručka. Brno. Computer Press 2009.
MATIAŠKO, K.: Databázové systémy. ŽU Žilina. EDIS. 2002
POKORNÝ, J.: Databázové systémy a jejich použití v informačníchsystémech. Academie PRAHA. 1992.
POKORNÝ, J.: Dotazovací jazyky. SCIENCE. 1994.

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

ABCDEFX
21,2 %26,1 %25,5 %16,8 %9,8 %0,6 %
Name of lecturer(s): Ing. Marcela Hallová, PhD. (examiner, instructor, lecturer)
doc. PaedDr. Peter Polakovič, Ph.D. (person responsible for course)
Last modification: 21. 8. 2019
Supervisor: doc. PaedDr. Peter Polakovič, Ph.D. and programme supervisor


Last modification made by Iveta Kunová on 08/21/2019.

Type of output: