suomeksi
in English
Database Management (D0114), 4 op
Basic information
| Course name: | Database Management Database Management |
| Course Winha code: | D0114 |
| Kurre acronym: | DBManag |
| Credits: | 4 |
| Type and level of course: | Professional studies |
| Year of study, semester or study period: | 2.year |
| Implementation: | Spring semester, 3.period, 4.period |
| Semester: | 0607 |
| Language of tuition: | English |
| Teacher: | Aarne Klemetti |
| Final assessment: | Grading scale (0-5) |
Descriptions
Prerequisites
D0127 Introduction to Programming
TIEL0004 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 are applied a design application and different commercial and open source database management applications.
Core content level learning outcomes (knowledge and understanding)
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.
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 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.
Recommended reading
Elmasri, Navathe: Fundamentals of Database Systems
Hernandez: Databases for Mere Mortals
Teaching and learning strategies
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: -
Teaching methods and student workload
Assessment weighting and grading
Assessment of the compulsory homework assignments and the project. Final exam.