545-0117/06 – Database Systems (DBS)

Gurantor departmentDepartment of Economics and Control SystemsCredits5
Subject guarantorIng. Filip Beneš, Ph.D.Subject version guarantorIng. Filip Beneš, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction1999/2000Year of cancellation2018/2019
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BEN170 Ing. Filip Beneš, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 6+6

Subject aims expressed by acquired skills and competences

The objective of subject is development of basic questions and facilitys in the area of modelling of reality with a view to proposal and creating of database systems (DBS). Students will informed about history of data processing, basic terminology in the area of databases, data types, particular database models and ways of theirs creation. In practical part students will informed about proposal and physical realization of database in environment of software Microsoft Access. At the close students create semestral project intent on proposal and realization of database.

Teaching methods

Lectures
Tutorials
Project work

Summary

Modelování reality. Informační systém. Datové typy. Databázový systém(DBS). SŘBD a jeho funkce. Tři úrovně struktury DBS. Výhody databázové technologie. Architektura DBS. Interní formy uložení dat. Konceptuální schéma. ERA diagram. Vztahy mezi entitami. Jiné modely k.s. Funkční analýza. Diagram toku dat. Síťový datový model, síťové DBS. Hierarchický datový model, hierarchické DBS. Relační datový model, relační DBS a jeho podmínky. Klíče a integrita relačních DBS. Funkční závislosti. Normalizace relačních tabulek. Dotazování nad relační DB. SQL, QBE. Ochrana DBS. Řízení paralelních procesů v databázích. Přístup k výstavbě DBS a IS.

Compulsory literature:

1. SIMSION, G.; WEST, M.; WITT, G.: Data Modeling Essential. Elsevier Science & Technology, 2004, 560 pages, ISBN: 978-0-12-644551-0. 2. BALTER, A.: Access 2013 Absolute Beginner’s Guide. Pearson Education, Inc., 2013, 388 pages, ISBN: 978-0-7897-4871-3.

Recommended literature:

1. VINE, M.: Microsoft Access VBA Programming for the Absolute Beginner. Thomson Course Technology, 2002, 328 pages, ISBN: 1-59200-723-6.

Way of continuous check of knowledge in the course of semester

Znalostní testy

E-learning

Další požadavky na studenta

Individuální, dle bližší specifikace vedoucího cvičení.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Introduction to databases, types of databases 2. Data types in relational databases 3. Tables + CRUD (SQL) 4. Design of relational databases - ERD models 5. Access to data, ODBC, ADO, DTS 6. Indexes 7. Stored procedures, triggers, views, cursors 8. Transaction 9. Databases safety and backups 10. NoSQL databases 11. Object databases, Caché 12. Big Data 13. Data analyses, introduction to BI 14. Transact-SQL

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester, validity until: 2012/2013 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 33 (33) 0
                Project Project 33  0
        Examination Examination 67 (67) 0
                Written examination Written examination 33  0
                Oral Oral examination 34  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2018/2019 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 1 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 1 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 1 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 1 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 1 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 1 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 1 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 1 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 1 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 1 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 1 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 1 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 1 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 1 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 1 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 1 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 1 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 1 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (3902R006) Automation and Computers in Raw Material Industry P Czech Ostrava 3 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 1 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 1 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 1 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 2 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (3902R006) Automation and Computers in Raw Material Industry P Czech Ostrava 3 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 1 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 2 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 1 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 1 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (3902R006) Automation and Computers in Raw Material Industry P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 2 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 2 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 2 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 2 Compulsory study plan
2008/2009 (B2102) Mineral Raw Materials (3902R006) Automation and Computers in Raw Material Industry P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2102) Mineral Raw Materials (3902R006) Automation and Computers in Raw Material Industry P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 2 Compulsory study plan
2007/2008 (B2102) Mineral Raw Materials (6209R013) Information and System Management P Czech Ostrava 2 Compulsory study plan
2007/2008 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Ostrava 2 Compulsory study plan
2007/2008 (B2102) Mineral Raw Materials (6209R013) Information and System Management K Czech Most 2 Compulsory study plan
2006/2007 (B2102) Mineral Raw Materials (3902R006) Automation and Computers in Raw Material Industry P Czech Ostrava 3 Compulsory study plan
2006/2007 (B2102) Mineral Raw Materials (3902R033) System Engineering in Raw Materials Industry P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
ECTS - FMG 2018/2019 Full-time English Optional 501 - Study Office stu. block
ECTS - FMG 2017/2018 Full-time English Optional 501 - Study Office stu. block
ECTS - FMG 2016/2017 Full-time English Optional 501 - Study Office stu. block
Subject block without study plan - HGF - P 2014/2015 Full-time Czech Optional HGF - Faculty of Mining and Geology stu. block