Database Management (D0114), 4 op

Perustiedot

Esitietovaatimukset

D0127 Introduction to Programming
TIEL0004 Application Development

Sisältö (ydinaines ja -osaaminen)

- 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

Sisältö (täydentävä ja erityisosaaminen)

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

Tiedolliset oppimistulokset (ydinaines ja -osaaminen)

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

Taidolliset oppimistulokset (ydinaines ja -osaaminen)

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 being 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 being emphasized by getting acquainted to data warehouses existing behind the decision support systems. Also different reporting methods and data mining are introduced in the same context.

Kirjallisuus ja muu materiaali

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

Opetusmenetelmät

Class room teaching: 28 h
Laboratory excercises:21 h
Project: 20 h
Exams: 2 + 2 h
Student individual workload: 47 h
Total: 120 h
Follow-up of the student workload analysis performed: -

Opiskelijan kuormittavuus

Arvioinnin perusteet

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

Koulutusohjelmakohtaiset kompetenssit