Data ManagementLaajuus (5 ECTS)

Objective

Having passed the unit the student understands the importance of databases as parts of information systems. The students 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. The student is able to create application that store and retrieve persistent data in a database using different techniques including standard ORM solutions.

Content

- Data models and information systems
- Conceptual modelling.
- Relational algebra and relational model, Normalization.
- Principles of relational databases.
- Implementation of a relational database, Data definition language, Data manipulation language, SQL.
- Query processing
- Indexes and integrity
- Transactions and management of concurrency
- Application development and databases, Programmatic SQL

Qualifications

Completing first year study modules in Information Technology or equivalent skills and knowledge.

Assessment criteria, satisfactory (1)

Students have achieved the course objectives fairly. Students will be able to identify, define and use the course subject area’s concepts and models. The student understands the criteria and principles of the expertise development.

Assessment criteria, good (3)

Students have achieved the course objectives well, even though the knowledge and skills need improvement on some areas. Students are able to define the course concepts and models and are able to justify the analysis. The student is able to apply their knowledge in leisure, study and work situations. The student understands the importance of expertise in the field of information technology and is able to analyze his/her own expertise.

Assessment criteria, excellent (5)

Students have achieved the objectives of the course with excellent marks. Students master commendably the course subject area’s concepts and models. Students are able to make justified and fluent analysis and to present concrete development measures. The students are well prepared to apply their knowledge in leisure, study and work situations. Students are able to analyze the information technology sector expertise and the evolvement of their own expertise.