Data Management and Databases (5 cr)

Code: SOF001AS2AE-3013

Basic information of implementation

Enrollment: 02.06.2025 - 15.08.2025; Enrollment for the implementation has begun.

Timing: 18.08.2025 - 12.12.2025; The implementation has not yet started.

ECTS Credits: 5 cr

Campus: Pasila Campus

Teaching languages: English

Seats: 15 - 30

Degree programmes: ITBBA Business Information Technology

Teachers: Kalle Ilves

Groups: ITE2PAICB1
Business Information Technology, 2nd semester, ICT and Business, Pasila, group 1; CONTACT
Contact implementation; ITE2PASOF1
Business Information Technology, 2nd semester, Software Development, Pasila, group 1

Course: SOF001AS2AE

Evaluation scale

H-5

Schedule

Weekly contact classes.
Mid-term exam after the first period and final exam at the end of the semester.

*** IMPORTANT ***
You will be required to confirm your course participation by completing a given set of exercises before the second course week's class.

Implementation methods, demonstration and Work&Study

a. Contact lessons, assignments, case assignment, and independent studies OR
b. Self-study, assignments, case assignment, and written examinations

Assessment
* Weekly hands-on lab assignments, a comprehensive group work case assignment, activity in the group, learning diary, and two written exams

If you already have achieved the required learning objectives of this course, then you can show your competence with a portfolio and a demonstration exam. Please contact the teacher of the course if you need any advice on this matter. Recognition of prior learning should be applied for prior commencing the course.
See also: Further information regarding the recognition of prior learning

Intro

In this course, you learn the basics that will make it possible for you to design and implement a small relational database and write intermediate-level database queries to retrieve and manipulate the database's data. The weekly cooperative database lab sessions and hands-on exercises in the SQL Server environment will give you practical experience and help you to learn the course content in a motivating way.

Materials

The course material is available in Moodle.

Teaching methods and instruction

Contact classes and weekly coursework.

Teams group for questions and instruction.

Prerequisite
The prerequisite is that you have passed the course Introduction to Software Development (SOF001IT1AE) or another equivalent course, or you can demonstrate equivalent skills and knowledge prior commencing the course.

Exam dates and re-exam possibilities

Mid-term exam and final exam.
The exam dates are available in Moodle.
There are two re-exams in spring 2025.

Internationality

The course is in English. Usually, there are participants from different nationalities.

Learning assignments

There are individual weekly assignments and a comprehensive group work case assignment. These are available in Moodle.

Assessment methods

Mid-term exam and final exam.
The coursework might raise/lower the course grade by one.

*** IMPORTANT ***
* The required minimum amount of coursework should be completed before the final exam.

* Haaga-Helia's policy: When the implementation type of the course is contact, online or blended it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25%, your grade will be lowered by one. If you are absent more than 50%, the course is failed.