Database ManagementLaajuus (4 ECTS)

Objective

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

Core content level learning outcomes (skills)

After completing the course the student is capable of assessing the demand, usage, and application of a 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 designed and implemented.
Also the practices of using SQL as the data design and manipulation language are 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.

Content

• 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 the 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
• Introduction to ontology

Course contents (additional)•

• A design application and different commercial and open source database management applications are applied as practical tools on the course.

Qualifications

Introduction to programming and application development

Assessment criteria, satisfactory (1)

The student can define and model simple databases and map them to a RDBMS application. In addition to that he/she can create simple reports.

Assessment criteria, good (3)

The student can administer a database system and understands the principles of transaction management. He/she understands the principles of OLAP.

Assessment criteria, excellent (5)

The student can create complex relational databases and can assess the usage of different database systems and paradigms. He/she can also use and evaluate the feasibility of OLAP and data mining with large datasources.