155-0379/01 – Administration of Database Systems (SDBS)

Gurantor departmentDepartment of Computer ScienceCredits5
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction2007/2008Year of cancellation2013/2014
Intended for the facultiesEKFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BOC05 Ing. David Bochenek
MAR0011 prof. Ing. Dušan Marček, CSc.
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2

Subject aims expressed by acquired skills and competences

Describe and use most commands DDL and DML of SQL language. Outline such key words like database, table, view, function, stored procedure, trigger, transaction. Create databases in Microsoft SQL Server a these databases control. Create database projects in Microsoft Office Access set on Microsoft SQL Server.

Teaching methods

Lectures
Tutorials
Project work

Summary

Subject Administration of database systems continue subject Database applications. His main aim is to introduce students with administration efficient database systems like are e.g. Microsoft SQL Server or MySQL and extend further knowledge of SQL language.

Compulsory literature:

GROFF, James R. a Paul N. WEINBERG. SQL: The Complete Reference. McGraw-Hill Osborne Media. 912 p. ISBN 978-0071592550. MISTRY, Ross. Microsoft SQL Server 2008 management and administration. Indianapolis: Sams Publishing, 2009. 880 p. ISBN 978-0-672-33044-5

Recommended literature:

... and anything else about MS SQL Server and SQL language.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Credit: project Exam: oral

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Introduction to database technology: basic data processing concepts, historical development and the reasons for the emergence 2. Main features of database technology 3. Database management system, database architecture, life cycle 4. Components of database management system 5. Data models - principles of functional and data analysis 6. Physical data models and methods of physical data organization 7. Relational data model: relations, attributes, schemas, relationships 8. Relational languages​​: a language for data definition 9. Dependency theory, decomposition of relational schemas 10. Normal forms of relations 11. Conceptual data models, Entity-Relationship modeling 12. Network and hierarchical data model 13. Distributed database systems 14. Data warehousing: concepts, architecture, models, operations, diagrams tables of facts and dimensions, types of DS

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester, validity until: 2013/2014 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 45 (45) 0
                Other task type Other task type 45  0
        Examination Examination 55 (55) 0
                Oral Oral examination 55  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2012/2013 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 3 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 3 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 3 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 3 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics P Czech Valašské Meziříčí 3 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 3 Compulsory study plan
2009/2010 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 3 Compulsory study plan
2009/2010 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 3 Compulsory study plan
2008/2009 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 3 Compulsory study plan
2008/2009 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 3 Compulsory study plan
2007/2008 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 3 Compulsory study plan
2007/2008 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner