352-0060/01 – Information and Transmission Systems (InfPS)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantorprof. Ing. Radim Farana, CSc.Subject version guarantorprof. Ing. Radim Farana, CSc.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year5Semesterwinter
Study languageCzech
Year of introduction1990/1991Year of cancellation2008/2009
Intended for the facultiesFSIntended for study typesMaster
Instruction secured by
LoginNameTuitorTeacher giving lectures
FAR10 prof. Ing. Radim Farana, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Part-time Credit and Examination 8+4

Subject aims expressed by acquired skills and competences

Teaching methods

Summary

Compulsory literature:

Recommended literature:

Additional study materials

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Relační databáze, základní relační operace, relační algebra 2. Datová analýza a návrh tabulek, metodika datové analýzy, normální formy relace, dokumentace datových toků, distribuce zdrojů. 3. SQL server, možnosti, nástroje pro správu. 4. Tvorba tabulek, datové typy, omezení. 5. Zajištění referenční integrity a konzistence databáze. 6. SQL - DDL 7. SQL -DML 8. SQL - DCL 9. Uložené procedury a spouště 10. OLAP analýza dat 11. Datamining, možnosti a využití 12. Metodika tvorby informačního systému, požadavky a jejich realizace. 13. Možnosti a využití ADO.NET.

Conditions for subject completion

Part-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (145) 51 3
        Examination Examination 100  0 3
        Exercises evaluation Credit 45  0 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2006/2007 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2005/2006 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2004/2005 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2004/2005 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management P Czech Ostrava 4 Choice-compulsory study plan
2003/2004 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2003/2004 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management P Czech Ostrava 4 Choice-compulsory study plan
2002/2003 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2002/2003 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management P Czech Ostrava 4 Choice-compulsory study plan
2001/2002 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2001/2002 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management P Czech Ostrava 4 Choice-compulsory study plan
2000/2001 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management K Czech Ostrava 5 Choice-compulsory study plan
2000/2001 (M2301) Mechanical Engineering (3708T018) Design Operation and Maintenance of Vehicles (30) Transport Economics and Management P Czech Ostrava 4 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.