Database ManagementLaajuus (4 ECTS)

Objective

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 can assess them successfully.
-----
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 being designed and implemented.
Also the practices of using SQL as the data design and manipulation language are carried out in lectures and exercises.

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

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