28. 2. 2020  9:33 Zlatica
Akademický informační systém

Sylabus předmětu DTBZ06_6B - Databases (MTF - WS 2019/2020)


     Informačný list          ECTS          Sylabus          


     Slovenština          Angličtina          


University: Slovak University of Technology in Bratislava
Faculty: Faculty of Materials Science and Technology in Trnava
Course unit code: DTBZ06_6B
Course unit title: Databases
Mode of delivery, planned learning activities and teaching methods:
lecture2 hours weekly (on-site method)
26 hours per semester of study (combined method)
seminar2 hours weekly (on-site method)
26 hours per semester of study (combined method)

 
Credits allocated: 6
 
Recommended semester/trimester: Applied Informatics and Automation in Industry - bachelor (compulsory), 3. semester
Applied Informatics and Automation in Industry - bachelor (compulsory), 3. semester
Mechatronics in Technological Equipment - bachelor (compulsory), 5. semester
Mechatronics in Technological Equipment - bachelor (compulsory), 5. semester
Quality of Production - bachelor (compulsory), 5. semester
Quality of Production - bachelor (compulsory), 5. semester
Level of study: 1.
Prerequisites for registration: none
 
Assesment methods:
-- item not defined --
 
Learning outcomes of the course unit:
The student will master the principles of data modeling and obtain practical experience from the data base design. Understand the use of query languages for working with databases, and can work with SQL language and PL / SQL procedural language.
 
Course contents:
- The life cycle of database design.
- Data modeling: conceptual model, logical model, physical model.
- Object-oriented data modeling.
- SQL language.
- SQL functions.
- PL / SQL language.
- Optimizing SQL commands.
 
Recommended or required reading:
Basic:
CONOLLY, T. -- BEGG, C. -- HOLOWCZAK, R. Mistrovství - databáze: Profesionální průvodce tvorbou efektivních databází. Brno : Computer Press, 2009. 584 p. ISBN 978-80-251-2328-7.
DELIKÁT, T. Základy projektovania databázových systémov. Bratislava : DELINT, 2007. 207 p. ISBN 978-80-969613-0-6.
TANUŠKA, P. -- SCHREIBER, P. -- VAŽAN, P. Informačné systémy - dátové modely. 2003.
TANUŠKA, P. -- SCHREIBER, P. -- VAŽAN, P. Informačné systémy II. Trnava : Tripsoft, 2004. ISBN 80-968734-6-6.
MATIAŠKO, K. -- VAJSOVÁ, M. -- ZÁBOVSKÝ, M. -- CHOCHLÍK, M. Databázové systémy a technológie. STU v Bratislave FIIT, 2009. 693 p. ISBN 978-80-227-3035-8.
LACKO, L. SQL hotová řešení. Praha: Computer Press, 2003. ISBN 80-7226-975-5.
SCHMULLER, J. Myslíme v jazyku UML: Knihovna programátora. Praha : Grada Publishing, 2001. 359 p. ISBN 80-247-0029-8.

 
Language of instruction: slovak or english
 
Notes:
 
Courses evaluation:
Assessed students in total: 614

ABCDEFX
13,5 %18,6 %21,8 %21,7 %21,7 %2,7 %
Name of lecturer(s): Ing. Martin Juhás, PhD. (examiner, instructor) - slovak
Ing. Lukáš Špendla, PhD. (examiner, instructor, lecturer, tutor)
prof. Ing. Pavol Tanuška, PhD. (examiner, instructor, lecturer, person responsible for course, tutor) - slovak
 
Last modification: 20. 12. 2018
Supervisor: prof. Ing. Pavol Tanuška, PhD. and programme supervisor


Last modification made by Bc. Jana Rohaľová on 12/20/2018.

Typ výstupu: