|
Lecturer(s)
|
|
|
|
Course content
|
Database systems as a technology platform for corporate information systems. Data processing, database technology. Database system architecture, relational data model. Data Modeling Approaches. Principles of structured modeling, modeling of entities and relationships. Principles of Object-Oriented Modeling Modeling standard Unified Modeling Language, modeling of objects and classes. Transforming an analytical model into a relational data model. Normalize the relational data model. Requirements for data in database systems, data integrity. Language resources, introduction to the database standard Structured Query Language. Principles of transactional systems with operational data and basic principles of data warehouses.
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Laboratory work
- Contact teaching
- 39 hours per semester
- Home preparation for classes
- 39 hours per semester
- Preparation for an exam
- 50 hours per semester
- Preparation for a partial test
- 22 hours per semester
|
|
Learning outcomes
|
The aim of the course is to acquire basic theoretical knowledge about the database systems with a focus on relational systems, with an emphasis on the application of structured and object-oriented approach to data modeling.
A student who has successfully completed the course can: to characterize types of database systems, in particular the relational database systems; explain the role of database systems in organizations and their application in corporate information systems; define principles of data modeling; to characterize data modeling tools in the analysis and design of the information system; describe the logic of data model development in accordance with the principles of relational database systems; explain the nature of data integrity and ways of ensuring it; to characterize the principles of transactional systems and data warehouses.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Oral examination, Written examination, Didactic test, Discussion
The assignment: elaboration of partial tests, elaboration of assigned tasks, attendance at seminars in accordance with FEA directive. The examination: consists of a written and an oral part; the degree of knowledge and ability to apply acquired knowledge to solving practical problems is tested, the condition is to obtain credit.
|
|
Recommended literature
|
-
Coronel,C. Database Principles - Fundamentals of Design, Implementation, and Management. Andover Cengage Learning EMEA, 2013.
-
Unhelkar, B. Software Engineering with UML. 2018.
|