638-3004/01 – Database applications design (TDA)

Gurantor departmentDepartment of Automation and Computing in IndustryCredits6
Subject guarantorIng. Romana Garzinová, Ph.D.Subject version guarantorIng. Romana Garzinová, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semestersummer
Study languageCzech
Year of introduction2014/2015Year of cancellation2019/2020
Intended for the facultiesFMTIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
OVC37 Ing. Romana Garzinová, Ph.D.
HEG30 doc. Ing. Milan Heger, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 3+2
Part-time Credit and Examination 18+0

Subject aims expressed by acquired skills and competences

Student will be able to create basic database query in T-SQL. Student will understand database application design in MS.NET Framework environment. Student will be able to effectively design and use database models in MS SQL Server. Student will be able to process data in various application environments.

Teaching methods

Lectures
Tutorials
Project work

Summary

A subject is focused to create T-SQL queries in database server MS SQL Server 2012 and basic database applications design using ADO. NET. Students will be familiar with data presentation in term of APS.NET, WPF and further will be described a distributed application (SOA) with help of WCF.

Compulsory literature:

TROELSEN, Andrew W. Pro C# 5.0 and the .NET 4.5 Framework. 6th ed. New York: Apress, c2012. ISBN 978-1-4302-4234-5. SHARP, J. Microsoft Windows Communication Foundation step-by-step [CD-ROM]. Redmond: Microsoft Press, c2007. ISBN 978-0-7356-2336-1.

Recommended literature:

ERL, T. SOA: principles of service design. Upper Saddle River: Prentice Hall, c2008. ISBN 978-0-13-234482-1.

Way of continuous check of knowledge in the course of semester

E-learning

Integrovaný systém modulární počítačové podpory výuky ekonomicko-technického zaměření (http://lms.vsb.cz)- Vzdělávací modul 1 – Počítačové systémy řízení metalurgických procesů. GARZINOVÁ, R. Tvorba databázových aplikací. Studijní opory Ostrava: VŠB-TU Ostrava, 2015.

Other requirements

Elaborating term project on a given topic

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. A subject introduction – methods of data collection, general 3-layer architecture and modern technological trend of software development. 2. Acquaint with MS SQL 2012 architecture and basic structure of T-SQL query. 3. Data acquisition from one or more data sources (SELECT, JOIN). 4. Sorting and data filtering. Working with data types. Application of system functions in query. Grouping and data aggregation. 5. Application of procedures for activation, using and working with saved procedures in SQL Server. 6. Query optimization, exceptions treatment, errors detection and transact data processing. 7. Introduction to MS .NET Framework, Object-Oriented Programming. 8. Core C# Programming. 9. Database applications design of in ADO .NET. 10. EDM (Entity Data Model) – working with entity data models in MS .NET environmnet. 11. SOA – Service Oriented Architecture. 12. WCF – distribute systems design in .NET. 13. ASP .NET- web technology for data presentation. 14. WPF, WinForm – data presentation in MS Windows.

Conditions for subject completion

Part-time form (validity from: 2014/2015 Winter semester, validity until: 2019/2020 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 (100) 51
        Exercises evaluation Credit 35  25
        Examination Examination 65  26 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
2019/2020 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies K Czech Ostrava 1 Compulsory study plan
2019/2020 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies P Czech Ostrava 1 Compulsory study plan
2018/2019 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies P Czech Ostrava 1 Compulsory study plan
2018/2019 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies K Czech Ostrava 1 Compulsory study plan
2017/2018 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies P Czech Ostrava 1 Compulsory study plan
2017/2018 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies K Czech Ostrava 1 Compulsory study plan
2016/2017 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies P Czech Ostrava 1 Compulsory study plan
2016/2017 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies K Czech Ostrava 1 Compulsory study plan
2015/2016 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies P Czech Ostrava 1 Compulsory study plan
2015/2016 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies K Czech Ostrava 1 Compulsory study plan
2014/2015 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies P Czech Ostrava 1 Compulsory study plan
2014/2015 (N3922) Economics and Management of Industrial Systems (3902T042) Automation and Computing in Industrial Technologies K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2018/2019 Summer
2017/2018 Summer
2016/2017 Summer
2015/2016 Summer
2014/2015 Summer