FPF:UIBUC10 Database systems I - Course Information
UIBUC10 Database systems I
Faculty of Philosophy and Science in OpavaWinter 2018
- Extent and Intensity
- 2/2/0. 5 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- prof. Ing. Dušan Marček, CSc. (lecturer)
RNDr. Miroslav Langer, Ph.D. (seminar tutor) - Guaranteed by
- prof. Ing. Dušan Marček, CSc.
Institute of Computer Science – Faculty of Philosophy and Science in Opava - Prerequisites (in Czech)
- UIAI210 Introduction to Logic || UIBUC12 Introduction to Logic || UIKKB14 Introduction to Logic || UIKSB21 Introduction to Logic || UINK107 Introduction to Logic || UIN1007 Introduction to Logic
Znalost programování, znalost operačních systémů, základy informatiky
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
- fields of study / plans the course is directly associated with
- Computer science in combination with another discipline (programme FPF, B1803 InDO)
- Course objectives
- The course focuses on DB technology for their utilization and application in enterprices and institutions. The aim is to understand the use of DB technology, their theoretical background practical design and deployments, offers an understanding of DB architectures and understanding of their implementation.
- Syllabus
- 1. Introduction to data base systems
2. Database management systems
3. The architectures of databases
4. Components of database systems
5. Date description language
6. Date manipulation language
7. Models of database
8. Relational database model
9. Internal data organization
10. Theory of dependencies
11. Normal forms of database
12. Design of relational databases
Activities
None
Garantors and lectures
* Guarantor: Prof. Ing. Dušan MARČEK, CSc.
* Lecturer: Prof. Ing. Dušan MARČEK, CSc.
* Tutorial lecturer: RNDr. Miroslav LANGER, Ph.D.
Literature
* Basic: MARČEK, M.: Technologie zpracování dat, databázové zpracování. SU, FPF, Ústav informatiky, Opava, 2008 , ISBN: 978-80-7248-480-5.
* Further literature: HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. 10. vyd. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4.
* Recommended: POKORNÝ, J. a kol.: Databázové systémy a jejich použití v informačních systémech. Praha, ČVUT, 1998.
Prerequisities
None
Other requirements
1 ongoing test, combined exam
- 1. Introduction to data base systems
- Literature
- required literature
- MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, 2008. ISBN 978-80-7248-480-5. info
- recommended literature
- POKORNÝ, J. a kol. Databázové systémy a jejich použití v informačních systémech. Praha, ČVUT, 1988. info
- not specified
- GROFF, R. James a Paul N. WEINBERG. SQL kompletní průvodce. Brno, 2005. ISBN 80-251-0369-2. info
- Teaching methods
- Interactive lecture
Lecture with a video analysis - Assessment methods
- Exam
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- The course can also be completed outside the examination period.
- Teacher's information
- Theoretical understanding of topic specified in Scope of Contents
Demonstration practical skills in database design
- Enrolment Statistics (Winter 2018, recent)
- Permalink: https://is.slu.cz/course/fpf/winter2018/UIBUC10