Learning outcome

After successfully completing the course, the candidate will have achieved the following learning outcomes defined in terms of knowledge, skills and general competence.

Knowledge:

In programming:

• Can describe the basic programming elements that are common to most programming languages, including the use of variables, data types, decisions, methods, parameters, various data structures, looping, file management and Exception Handling
• Can describe the essential properties and methods of a variety of visual and non-visual components and is able to write code for these
• Can describe techniques for using library files developed by other programmers
• Can describe the basic object-oriented principles
• Can derive classes with properties and methods, and create and use objects

In databases:

• Can describe the structure and operation of a database management system
• Can describe the fundaments of the relational database model
• Masters the syntax for basic SQL queries, and stored procedures and triggers
• Has knowledge of the relevant theory for database design using E-R diagrams
• Can resolve a database based on the E-R model to a corresponding table structure
• Can verify a table structure using normalization theory
• Can describe and give examples of the principles of database transactions

Skills:

• Can independently develop event-driven computer programs (applications) using an object-oriented programming language, in which the elements described above are included
• Can (using E-R diagrams) design a system for storing data according to the principles of relational theory and on the basis of this can build, implement and use a database in a an application that he/she has developed
• Masters SQL sufficiently to develop queries, define data structures, and to define user rights
• Masters the use of an integrated development environment (Application) for object-oriented application development and Application
• Masters the use of a modelling tool for E/R-modelling and realization of databases
• Masters the use of a Database Management System (DBMS), inclusive table management, SQL, import/export of data, stored procedures and triggers

General competence

• Has insight into the development stages which are typically included in the development of applications/software and has thus acquired the basis for being able to collaborate with other developers in software development

Course Description

An introduction to software development using object-oriented programming languages, ​​as well as database modelling, implementation and use of databases in applications.

The main content is divided into two parts: one part focuses on basic programming and the other part focuses on basic database development and management. However, the two parts will also be considered as a whole.

Teaching and Learning Methods

The teaching and learning methods include lectures, exercises and independent study.

Skills will be developed through the active development of programs, where students will use their own laptops.

Assessment Methods

There are two mandatory assignments during the course (approved / not approved). One of them is a Programming task, while the other is a combined Programming- and Database-task. Both must be delivered within the date/time specified in the course schedule. Both assignments must be approved before the students will be permitted to take the final examination.

In addition there will be a final examination (100 %), where individual, graded marks will be given. Students must receive passing marks (i.e. minimum grade E) in the final examination in order to pass the course.

Minor adjustments may occur during the academic year, subject to the decision of the Dean