714-0393/02 – Database Systems (DBS)

Gurantor departmentDepartment of Mathematics and Descriptive GeometryCredits2
Subject guarantorMgr. Petr OtipkaSubject version guarantorPaedDr. Zdenka Homolová
Study levelundergraduate or graduateRequirementOptional
Year3Semestersummer
Study languageCzech
Year of introduction2000/2001Year of cancellation2009/2010
Intended for the facultiesFSIntended for study types
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOM44 PaedDr. Zdenka Homolová
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Combined Graded credit 8+4

Subject aims expressed by acquired skills and competences

Introduction to basics of professional computer data storing and processing to database systems.

Teaching methods

Lectures
Individual consultations
Tutorials
Other activities

Summary

The subject introduces to basics of professional computer data storing and processing, to database systems. Although two most available models are described, the relational database model is preferred. The different data types are demonstrated regarding to theirs memory forms, ranges, access methods, and operations.

Compulsory literature:

Microsoft Access: Users Guide. Microsoft Corporation, Redmond(Wa,USA), 1999.

Recommended literature:

Miller, H. J. - Han, J.: Geographic Data Mining and Knowledge Discovery. ISBN 203468023. Taylor & Francis, London, 2001. Ponniah, P.: Database Design and Development. John Wiley & Sons, London, 2003.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Přednášky: Definice základních pojmů. Úrovně organizace dat. Struktura dat. Struktura uložení. Formy organizace dat. Organizace dat v systémech řízení báze dat. Základy teorie množin, matematická podstata relačních databází. Operace nad relacemi. Základy relačních databázových systémů. Dotazovací jazyky. Dotazovací jazyk SQL a jeho základní příkazy. Cvičení: Způsoby uložení dat, typy souborů a vazby mezi nimi. Režimy práce se systémem, dialog a program. Definice struktury databázového souboru a její změna. Naplnění databázového souboru a změny hodnot. Výrazy a funkce. Základní výstupní příkazy. Příkazy pro hromadnou manipulaci s daty. Interaktivní tvorba formulářů a jejich použití. Interaktivní tvorba výstupní sestavy. Ukázka programování.

Conditions for subject completion

Combined form (validity from: 1960/1961 Summer semester, validity until: 2009/2010 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded exercises evaluation Graded credit 100 (100) 0
        Project Project 40  0
        Other task type Other task type 60  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2009/2010 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2301R002) Transport Equipment K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2301R002) Transport Equipment K Czech Šumperk 3 Optional study plan
2009/2010 (B2341) Engineering (2302R003) Transport Machinery and Material Handling K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2302R007) Hydraulics and Pneumatics K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (20) Production Machines and Equipment K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (30) Earth Moving and Building Machines K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2302R010) Design of Machines and Equipment (70) Earth, Mining and Building Machines K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (3907R004) Energy Management K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2301R013) Robotics (70) Robotics K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2303R002) Mechanical Engineering Technology (70) Mechanical Engineering Technology K Czech Šumperk 3 Optional study plan
2009/2010 (B2341) Engineering (2301R040) Industrial Engineering K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (3904R016) Environmental Engineering (70) Environmental Engineering K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (2301R023) Technical Diagnostics, Service and Management (70) Technical Diagnostics, Repairs and Maintenance K Czech Ostrava 3 Optional study plan
2009/2010 (B2341) Engineering (3708R028) Transport Technology (20) Surface Transport K Czech Ostrava 3 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 3 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 3 Optional study plan
2008/2009 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 3 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 3 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 3 Optional study plan
2007/2008 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 3 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 3 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 3 Optional study plan
2006/2007 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 3 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Šumperk 3 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Uherský Brod 3 Optional study plan
2005/2006 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Třinec 3 Optional study plan
2004/2005 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan
2003/2004 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan
2002/2003 (B2341) Engineering (2341R888) Mechanical Engineering /not obligatory subject (70) Volitelné předměty K Czech Ostrava 3 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner