LV EN RU DE FR

Cross-Industry Software Development Project

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. Work Topic Selection (4h)
a. Identification and formulation of requirements
b. Planning and coordination with the instructor
2. Program Requirements Specification Preparation (15h)
a. Requirements analysis
b. Creation of a requirements document
3. Program Design Description Preparation (15h)
a. Selection and description of system architecture
b. Documentation of data structures and algorithms
c. Design of user interface
4. Version Control Tool Selection and Configuration (Development Environment Setup) (2h)
a. Overview of available version control tools
b. Configuration of the version control tool to meet project requirements
5. Program Prototype Development (20h)
a. Establishment of a fundamental program structure
b. Prototyping with minimal functionality
c. Testing
6. Program Documentation Correction (10h)
a. Review and necessary corrections to the documentation
7. User Documentation Preparation (10h)
a. Description of the user interface
b. Creation of instructions for operation
8. Program Operation Demonstration and Code Explanation (4h)
a. Preparation of an presentation
b. Live demonstration of program operation
c. Explanation of the code

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. C. Chauhan. 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. H. Dombrovskaya, A. Bailliekova, B. Novikov. PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries 1st ed. APress, 2021 – 319 pp.. Pieejams: LBTU ITF bibliotēka
4. M.Posadas. 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. O. Mehboob, A. Khan, J. Callaway, C. Hunt, R. Stephens. Improving Your C# Skills: Solve Modern Challenges with Functional Programming and Test-driven Techniques of C#. Birmingham : Packt Publishing. 2019 – 589 pp.
3. W.Angorro. Functional C#. Birmingham, UK : Packt Publishing. 2017 – 365 pp. 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

Professional Bachelor Study Program “Information
Technologies for Sustainable Development”