Siirry suoraan sisältöön

Tiedonhallinnan perusteet (3 cr)

Code: XX00AA79-3040

General information


Enrollment

23.08.2017

Timing

01.01.2020 - 31.12.2020

Number of ECTS credits allocated

3 op

Virtual portion

3 op

Mode of delivery

Distance learning

Unit

ICT ja tuotantotalous

Campus

Karaportti 2

Teaching languages

  • Finnish

Seats

0 - 99

Degree programmes

  • Tieto- ja viestintätekniikan tutkinto-ohjelma

Teachers

  • Virve Prami

Teacher in charge

Virve Prami

Groups

  • ATX20TV
    Avoin amk - NonStop vuosi 2020

Objective

Having passed the course, the student understands the importance of databases as part of information systems. The student is familiar with the relational model and other data models. The student is able to design and implement a relational database. The student is able to use and administer the database with a manipulation language.

Content

Data models and information systems. Conceptual modelling. Principles of relational databases. Implementation and normalisation of a relational database. Data definition language. Data manipulation language. SQL. Relational algebra.

Materials

N/A

Teaching methods

Online (Self-Study) course in Moodle environment

Employer connections

N/A

International connections

N/A

Completion alternatives

N/A

Further information

ENROLLING
Open UAS Student: Please fill in eform

Metropolia's Degree Student:
- Go to https://moodle.metropolia.fi/course/view.php?id=158 (Use Metropolia's Student ID)
- Enrolment key: Tihap14
- Follow instructions

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, satisfactory (1)

- The student understands the need for databases and their role as a part of an information system.
- The student is familiar with the idea and objective of conceptual modelling.
- The student understands the concepts of table, field, primary key and foreign key as well as integrity constraint in the context of the relational model.
- The student is able to identify the integrity constraints of the database. The student is able to identify other data models.
- The student knows the basic operations of relational algebra.
- The student is able to write queries on one table using selection criteria.
- The student is able to run the queries written by himself/herself on the database management system.

Assessment criteria, good (3)

- The student is able to explain the role of a database and the database management system in layered architecture.
- The student is able to apply the techniques of conceptual design.
- Based on a conceptual model the student is able to construct a relational schema with tables, fields, primary and foreign keys. The student is able to explain the meaning of integrity constraints.
- The student knows the basic ideas of other data models.
- The student understands the connection between query languages and relational algebra.
- The student is able to write SQL queries on several tables applying inner join operation.
- The student is able to write grouping SQL queries.
- The student is able to write a simple aggregation function related SQL queries.
- The student is able to implement a database on a database management system according to a given relational schema.

Assessment criteria, excellent (5)

- The student is able to describe the interaction between the database layer and other layers of an information system.
- The student is able to create a conceptual model from a verbal description of a target area.
- The student is able to convert a conceptual model to a relational schema with tables, fields, primary and foreign keys. The student is able to normalise a database schema to the third normal form. The student is able to compare the relational model with other data models.
- The student is able to write an expression of relational algebra that produces a desired result set.
- The student is able to use outer join and write queries with grouping on several factors and aggregate functions.
- The student is able to create a database based on a given relational schema and perform update operations on a database management system.
- The student is able to change the structure of an existing database.