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

Gurantor department	Department of Automation and Computing in Industry	Credits	5
Subject guarantor	Ing. Romana Garzinová, Ph.D.	Subject version guarantor	Ing. Romana Garzinová, Ph.D.
Study level	undergraduate or graduate	Requirement	Optional
Year	2	Semester	winter
		Study language	Czech
Year of introduction	2019/2020	Year of cancellation	2021/2022
Intended for the faculties	FMT	Intended for study types	Follow-up Master

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
OVC37	Ing. Romana Garzinová, Ph.D.

Extent of instruction for forms of study
Form of study	Way 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.

Additional study materials

Study supports in the EduDocs system

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, validity until: 2021/2022 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Credit and Examination	Credit and Examination	100 (100)	51
Credit	Credit	35	25
Examination	Examination	65	26	3

Mandatory attendence participation: Testing

Show history

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

Show history

Occurrence in study plans

Academic year	Programme	Branch/spec.	Zaměření	Form	Study language	Tut. centre	Year	Type 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) Quality Management and Control of Industrial Systems	(S03) Intelligent Control Systems in Industry	PI	P	Czech	Ostrava	2	Compulsory	study plan
2021/2022	(N0413A270002) Quality Management and Control of Industrial Systems	(S03) Intelligent Control Systems in Industry	PI	K	Czech	Ostrava	2	Compulsory	study plan
2020/2021	(N0413A270002) Quality Management and Control of Industrial Systems	(S03) Intelligent Control Systems in Industry	PI	K	Czech	Ostrava	2	Compulsory	study plan
2020/2021	(N0413A270002) Quality 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) Quality Management and Control of Industrial Systems	(S03) Intelligent Control Systems in Industry	PI	P	Czech	Ostrava	2	Compulsory	study plan
2019/2020	(N0413A270002) Quality 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 name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

2020/2021 Winter