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
-
ATX20TVAvoin 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.