Tiedonhallinta (L0015), 3 op

Basic information

Prerequisites

Introduction to Computing, Application Development

Course contents (core content level)

- Database structure and its implementation
- The fundamental components of a database
- Relational model and its applications
- ER modeling as a method of conceptual modeling
- Normalization
- The principles of SQL as data design, modification and query language
- Principles of indexing
- Transaction processing
- Temporal database management
- Principles of data warehousing, its structures and applications
- The impact of reporting in database management
- The differences in usage and operations of OLTP and OLAP systems
- Data mining

Course contents (additional)

As practical tools on the course a design application and different commercial and open source database management applications are applied.

Core content level learning outcomes (knowledge and understanding)

After completing the course the student knows the basics of database management process and its phases as well as methods and tools. The student is also capable of participating in the design processes of databases and assessing them successfully.

Core content level learning outcomes (skills)

After completing the course the student is capable of assessing the demand, usage, and application of database management system. For this purpose the most general design systems and their practices are introduced. The focus of the course is in relational database systems, and in both local and distributed applications. In laboratory exercises an incremental database system is being designed and implemented.

Also the practices of using SQL as data design and manipulation language are being carried out in lectures and exercises. The wide exploitation of databases is emphasized by getting acquainted with data warehouses existing behind the decision support systems. Also different reporting methods and data mining are introduced in the same context.

Recommended reading

Elmasri, Navathe: Fundamentals of Database Systems
Hernandez: Databases for Mere Mortals

Teaching and learning strategies

Class room teaching 28 h
Laboratory exercises 14 h
Project 10 h
Exams 2 h
Student individual workload 26 h
Total 80 h

Teaching methods and student workload

Assessment weighting and grading

Assessment of the compulsory homework assignments and the project. Final exam.

Related competences of the degree programme

Theoretical basis and mathematical and science skills
Information acquisition skills and adaptation of new knowledge
Communication and interpersonal skills