Relational Databases (5 cr)

Evaluation scale

0-5

Objective

Purpose of the course

Almost all information systems need databases to process information content. For example, social media services store every messages and comments in databases. This course will introduce you to relational database technologies. You will learn how to design and create database and how to process the data stored.

Course competences

- Information System Competence: Is familiar with typical information systems and services and understands the importance of security in utilizing services.
- Application Development Competence: Knows the technologies used in application development and recognizes the significance of different technologies and their relationships.
- Software Engineering Competence: Is able to define, plan and/or implement software products.
- Operating in a workplace: Utilizes the opportunities offered by technology and digitalization in their work.

The learning objectives of the course

After completing the course, you understand the concepts and theories related to databases. You know the different application domains of relational databases. You are able to make data modeling and can create a database based on a data model. You know how to use SQL language to work with relational databases.

Content

The course covers, for example, the following topics:

- Concepts and background theories related to databases
- Database technologies
- Database design and data modeling
- Implementing and using relational database
- SQL language

Location and time

The course will be delivered at Jamk's main campus.

Teaching methods

The basics of relational databases are studied independently by reading course materials and deepening understanding in contact lessons. The course includes many exercises in which concrete database-related situations and problems are solved.

Exam schedules

At the end of the course, either an exam or an assignment will be held. The exact dates and methods of completion will be determined at the beginning of the course.

Student workload

Approximately 135 hours.

Assessment criteria, satisfactory (1)

Sufficient 1: You know the application domains and basic functions of relational database technologies. You know the basics of data modelling. You are able to create a database and perform simple data processing operations.

Satisfactory 2: You know the application domains and basic functions of relational database technologies. You know the basics of data modelling. You are able to create a database and perform data processing operations.

Assessment criteria, good (3)

Good 3: You know the application domains and basic functions of relational database technologies. You understand the basics of conceptual modeling. You know how to implement a database based on the model. You know how to use the SQL language for maintenance and basic queries that require an understanding of joins, grouping and aggregate functions.

Very Good 4: You know the application domains and functions of relational database technologies. You are able to create a conceptual model of a narrow application area. You can implement a database based on the model. You know how to use the SQL language for maintenance and queries that require an understanding of joins, groupings, aggregate functions and subqueries.

Assessment criteria, excellent (5)

Excellent 5: You know the application domains and functions of relational database technologies. You are able to create a conceptual model of the application area can implement a suitable database for the application area. You master the SQL language and are able to apply it to generate the complex queries.