INMBPDTB Databases

School of Business Administration in Karvina
Winter 2014
Extent and Intensity
2/1/0. 6 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Milena Janáková, Ph.D. (lecturer)
doc. RNDr. František Koliba, CSc. (lecturer)
Mgr. Milena Janáková, Ph.D. (seminar tutor)
doc. RNDr. František Koliba, CSc. (seminar tutor)
Guaranteed by
doc. RNDr. František Koliba, CSc.
Department of Informatics and Mathematics – School of Business Administration in Karvina
Contact Person: doc. Mgr. Petr Suchánek, Ph.D.
Prerequisites
None
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
Course objectives
The course acquaints students with the basic knowledge of relational databases and practical implementation of simple problems in the MS ACCESS.
Syllabus
  • 1. Basic concepts and principles.
    2. DBS Architecture.
    3. The relational data model.
    4. DDL.
    5. Working with queries.
    6. SQL.
    7. QBE.
    8. Transactions.
    9. DBS Objects.
    10. Database management.
    11. Protection and security.
    12. Trends.
    13. Semester project.
Literature
    required literature
  • DATE, C.J. Database Design and Relational Theory: Normal Forms and All That Jazz. O'Reilly Media, 2012. ISBN 978-1449328016. info
  • FARANA, R. Databáze: speciální postupy. Český svaz vědecko technických společností, 2006. ISBN 80-02-01876-1. info
  • POKORNÝ, J., HALAŠKA I. Databázové systémy. ČVUT Praha, 1999. ISBN 80-01-01724-9. info
    recommended literature
  • LAMBERT, J., COX, J. Microsoft Access 2010 Step by Step. Microsoft Press, 2010. ISBN 978-0735626928. info
  • SCIORE E. Database Design and Implementation. J. Wiley & Sons, 2008. ISBN 978-0-471-75716-0. info
  • TANIAR, D., LEUNG, C. H. C., RAHAYU, W., GOEL, S. High Performance Parallel Database Processing and Grid Databases. J. Wiley & Sons Inc., 2008. ISBN 978-0-470-10762-1. info
  • POKORNÝ J., HALAŠKA, I. Databázové systémy. ČVUT Praha, 2004. ISBN 80-01-02789-9. info
  • HALAČKA, I., POKORNÝ, J., VALENTA, M. Databázové systémy: cvičení. ČVUT Praha, 2004. ISBN 80-01-02612-4. info
  • GARCIA-MOLINA, H., ULLMAN, J. D., WIDOM, J. systems : the complete book. Upper Saddle River, 2002. ISBN 0-13-031995-3. info
  • DOBSON R. Programování v Access 2000. Computer Press, 2000. ISBN 80-7226-721-8. info
  • LORENTS, A. C., MORGAN, J. N. Database systems. Concepts, Managements and Aplications The Dryden, 1999. ISBN 0-15-500029-2. info
  • ŠIMUNEK, M. SQL - Komplexní kapesní průvodce. Grada, 1999. ISBN 80-7169-692-7. info
  • POKORNÝ, J. Databázová abeceda. Veletiny : SCIENCE, 1998. ISBN 80-86083-02-0. info
  • ŠARMANOVÁ, J. Teorie zpracování dat. Ostrava : VŠB-TU Ostrava, 1997. ISBN 80-7078-491-1. info
  • SOKOLOWSKY, P., POKORNÝ, J., PETERKA, J. Distribuované databázové systémy. Praha, ČSAV, 1992. info
Language of instruction
Czech
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Teacher's information
Attendance in seminars 70 %, ongoing test, combined exam
The course is also listed under the following terms Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2019, Winter 2020, Winter 2021, Winter 2022, Winter 2023.
  • Enrolment Statistics (Winter 2014, recent)
  • Permalink: https://is.slu.cz/course/opf/winter2014/INMBPDTB