LV EN RU DE FR

Database Access Applications

Course developer

Prior knowledge

InfT2034, Database Access Applications

Course abstract

The aim of the course work is to apply, strengthen and expand knowledge about the creation of application programs that use relational database technologies for data management, as well as knowledge about various programming models for working with data sources and their use scenarios. Students have the opportunity to use active data objects for relational database data processing. Students apply and develop acquired practical skills in application programming for working with databases.

Learning outcomes and their assessment

As a result of the study course students:
• are able to demonstrate theoretical knowledge of creating applications for working with relational databases (program, program documentation, coursework defence);
• are able to define the purpose and tasks of the course work, choose and use the most appropriate methods in its development (program documentation)
• know how to code and debug programs, use good programming style, implement user interfaces, use data request languages (program);
• are able to independently code and debug program calculations, and to perform data processing tasks, implement user interfaces without using database management systems (program, program documentation, coursework defence).

Course Content(Calendar)

1. Selection of the topic of the course work and coordination with the supervisor. 2h
2. Preparing the database and connecting the program to the relational database. 8h
3. Program development. To perform data processing tasks, user interface implementation. 21h
4. Developing, designing and making the necessary corrections of the program documentation. 8h
5. Defence of the course work. 1h

Requirements for awarding credit points

Submitted and defended course work.

Description of the organization and tasks of students’ independent work

The student must develop the course work independently, using the advice of the responsible teaching staff, study literature and Internet resources.
The coursework must include:
• program
• program documentation

Criteria for Evaluating Learning Outcomes

The grade of the course work is formed from three parts - evaluation of the program (40%), evaluation of documentation (40%), defence and answers to questions (20%).

Compulsory reading

1. Chauhan C. PostgreSQL Cookbook. Birmingham: Packt Publishing, 2015. Pieejams: EBSCO e-book academic collection
2. Learning PostgreSQL: Create, Develop and Manage Relational Databases in Real World Applications Using PostgreSQL. Birmingham: Packt Publishing, 2015. Pieejams: EBSCO e-book academic collection
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: EBSCO e-book academic collection

Further reading

1. C# Tutorial [tiešsasite]. Pieejams: https://www.w3schools.com/cs/index.php
2. Improving Your C# Skills: Solve Modern Challenges with Functional Programming and Test-driven Techniques of C#. O. M. A. Khan, J. Callaway, C. Hunt, R. Stephens. 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ē
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.