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

Gurantor departmentDepartment of Automation and Computing in IndustryCredits5
Subject guarantorIng. Romana Garzinová, Ph.D.Subject version guarantorIng. Romana Garzinová, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semesterwinter
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesFMTIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
OVC37 Ing. Romana Garzinová, Ph.D.
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 16+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

Písemný test a ústní zkoušení.

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

Full-time form (validity from: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 35  25
        Examination Examination 65  26
Mandatory attendence parzicipation: Testing

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (N0713A070004) Thermal energetics engineering P Czech Ostrava 2 Optional study plan
2021/2022 (N0713A070004) Thermal energetics engineering K Czech Ostrava 2 Optional study plan
2021/2022 (N0413A270002) Quolity Management and Control of Industrial Systems (S03) Intelligent Control Systems in Industry PI P Czech Ostrava 2 Compulsory study plan
2021/2022 (N0413A270002) Quolity Management and Control of Industrial Systems (S03) Intelligent Control Systems in Industry PI K Czech Ostrava 2 Compulsory study plan
2020/2021 (N0413A270002) Quolity Management and Control of Industrial Systems (S03) Intelligent Control Systems in Industry PI K Czech Ostrava 2 Compulsory study plan
2020/2021 (N0413A270002) Quolity Management and Control of Industrial Systems (S03) Intelligent Control Systems in Industry PI P Czech Ostrava 2 Compulsory study plan
2020/2021 (N0713A070004) Thermal energetics engineering P Czech Ostrava 2 Optional study plan
2020/2021 (N0713A070004) Thermal energetics engineering K Czech Ostrava 2 Optional study plan
2019/2020 (N0413A270002) Quolity Management and Control of Industrial Systems (S03) Intelligent Control Systems in Industry PI P Czech Ostrava 2 Compulsory study plan
2019/2020 (N0413A270002) Quolity Management and Control of Industrial Systems (S03) Intelligent Control Systems in Industry PI K Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner