Course code InfT2034

Credit points 3

Database Access Applications

Total Hours in Course81

Number of hours for lectures16

Number of hours for laboratory classes16

Independent study hours49

Date of course confirmation18.10.2022

Responsible UnitInstitute of Computer Systems and Data Science

Course developers

author lect.

Jekaterina Smirnova

Mg. sc. ing.

author lect.

Ingus Šmits

Mg. sc. ing.

Prior knowledge

DatZ1009, Introduction to Programming I

DatZ1010, Introduction to Programming II

InfT2033, Windows Programming

Course abstract

The aim of the study course is to master the creation of application programs that use relational database technologies for data management, as well as to introduce students to various programming models for working with data sources and their use scenarios. Students are taught how to use active data objects for relational database data processing. As part of the course, scenarios of using active data objects for work in disconnected and connected mode are theoretically and practically examined. Students acquire practical skills in application programming for working with databases.

Learning outcomes and their assessment

As a result of the study course students:
• know about development applications for working with relational databases (laboratory work, independent work);
• know how to code and debug programs, use good programming style, implement user interfaces, use data request languages (laboratory work, independent work);
• are able to independently code and debug program calculations, and to perform data processing tasks, implement user interfaces without using database management systems (independent work).

Course Content(Calendar)

1. Connecting the program to the relational database - 2 hours
2. Reading data from the database - 2 hours
3. Adding, deleting and editing data in the database - 2 hours
4. A simple program for relational database data processing - 2 hours
5. Data transaction - 2 hours
6. Using the DataTable object - 2 hours
7. Using the DataAdapter object - 2 hours
8. Using the DataSet object and defining relations - 4 hours
9. Use of visual components for displaying and editing data - 4 hours
10. Binding data - 2 hours
11. Data selection and filtering - 2 hours
12. Dividing data into several windows - 2 hours
13. Work with recursive data structures - 4 hours

Requirements for awarding credit points

Completed laboratory works and independently developed application with database.

Description of the organization and tasks of students’ independent work

During the semester, the student must complete the laboratory works using the assignment descriptions using consultation with the head of the laboratory work and the lecturer.
The student must independently develop an application on the chosen topic, study literature and Internet resources.

Criteria for Evaluating Learning Outcomes

The exam grade is formed as an accumulative assessment from two parts - assessment of laboratory work (40%), assessment of independently developed application (60%).

Compulsory reading

1. Chauhan C. PostgreSQL Cookbook. Birmingham: Packt Publishing, 2015. Pieejams: datubāzē EBSCO e-book academic collection https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=946187&site=ehost-live&scope=site
2. Juba S., Vannahme A., Volkov A. Learning PostgreSQL: Create, Develop and Manage Relational Databases in Real World Applications Using PostgreSQL. Birmingham: Packt Publishing. 2015. Pieejams: datubāzē EBSCO e-book academic collection https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=1104912&site=ehost-live&scope=site
3. Dombrovskaya H., Bailliekova A., Novikov B. PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries. 1st ed. APress, 2021. 319 p. Pieejams: LBTU ITF bibliotēka
4. Posadas M. Mastering C# and .NET Framework. Birmingham: Packt Publishing. 2016.
Pieejams: datubāzē EBSCO e-book academic collection https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=1440572&site=ehost-live&scope=site

Further reading

1. C# Tutorial [tiešsasite]. Pieejams: https://www.w3schools.com/cs/index.php
2. Mehboob O., Khan A., Callaway J., Hunt C., Stephens R. Improving Your C# Skills: Solve Modern Challenges with Functional Programming and Test-driven Techniques of C#. Birmingham: Packt Publishing. 2019. 589 p.
3. Angorro W. Functional C#. Birmingham, UK: Packt Publishing, 2017. – 365 p. EBSCO e-book academic collection datubāzē https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=1446895&site=ehost-live&scope=site
4. .NET Documentation [tiešsaiste]. Pieejams: https://learn.microsoft.com/en-us/dotnet/

Periodicals and other sources

• EBSCO e-book academic collection. Pieejams: https://web-p-ebscohost-com.ezproxy.llu.lv/ehost/search/selectdb?vid=0&sid=8715372b-5e1d-4646-9ecc-530bf329861f%40redis

Notes

Compulsory course in Computer Science and Computer Science and Information Technology for Sustainable Development.