Database Systems I

  • Credits: 6
  • Ending: Examination
  • Range: 2P + 2C
  • Semester: winter
  • Year: 2
  • Faculty of Economic Informatics

Teachers

Included in study programs

Data Science in Economic

Economic Informatics

Teaching results

After completing the course, students should be able to:
A. know the principles and role of database systems
B. understand the process of effective data organization, protection and management
C. understand relational algebra and how queries are performed in relational databases;
D. understand the principles and techniques of concurrent work in database systems
E. analyze business requirements and, based on the results of the analysis, design and implement a standardized, relational data model;
F. work with SQL language in defining, manipulating and updating data, as well as controlling access to database objects.
G. Work with selected DBMSs;
H. Administer selected DBS at a moderate level.

Indicative content

Course content:
1. Introduction to the subject, history of information storage
2. Reality modelling, ANSI / SPARC architecture, conceptual models.
3. Entity-relationship model.
4. Data models, relational data model.
5. Transformation of conceptual models into logical data models.
6. Normalization and normal forms of relations.
7. Methodology of relational databases design.
8. Physical data models and their implementation in DBS.
9. Relational languages.
10. Data protection in database systems and principles of transaction processing.
11. Concurrency in DBS.
12. Object Oriented DBS.
13. DBS architectures

Support literature

ŠKURLA, P: Databázové spracovanie. In: PÓLYA, A. a kolektív: Informatika. Bratislava: Vydavateľstvo EKONÓM, 2008, s. 201 - 252. ISBN 978-80-225-2453-7
DATE, C.J: An Introduction to Database Systems (8th Edition), Addison-Wesley, 2003, s. 1024, ISBN: 978-0321197849
Scheber, A. Databázové systémy. Alfa-SNTL, 1988.
Veryard, R. Information Modelling - Practical Guidance. London : Prentice-Hall, 1992.
Veryard, R. Information coordination - The management of Information Models, Systems and Organizations. London : Prentice-Hall, 1994.
TEOREY, J. - Lightstone , S.- Nadeau, T. – Jagadish, H.V: Database Modeling and Design, Fifth Edition: Logical Design, Morgan Kaufmann, 2001, s. 352, ISBN 978-0123820204

Requirements to complete the course

60 % final exam: the exam consists of two parts: a test and an open task to design the database structure for the given environment. The test verifies the achieved level of learning outcomes A., B., C., D., by solving the task, the achieved level of learning outcomes E. and F are verified.
40 % assignments: The content of the exercise is the elaboration and defense of an individual project of database design and implementation in the selected DBMS with SQL interface through several assignments, which are evaluated separately. The overall evaluation is the sum of the points obtained for individual tasks. Through these assignments, the fulfilment of the learning outcomes E., F., G., H. is assessed.

Student workload

Total study load (in hours): 6 credits x 26 hours = 156 hours
Distribution of study load
Lectures and seminar participation: 52 hours
Preparation for seminars: 13 hours
Written assignments: 51 hours
Final exam preparation: 40 hours

Language whose command is required to complete the course

slovak

Date of approval: 10.02.2023

Date of the latest change: 18.05.2022