suomeksi
in English
Relaatiotietokannat ja sovelluskehittimet (T0061), 3 op
Basic information
| Course name: | Relaatiotietokannat ja sovelluskehittimet Relational databases and application generators |
| Course Winha code: | T0061 |
| Kurre acronym: | RelTK |
| Credits: | 3 |
| Type and level of course: | Professional studies |
| Year of study, semester or study period: | 2.year |
| Implementation: | Autumn semester, 2.period |
| Semester: | 0708 |
| Language of tuition: | Suomi |
| Teacher: | Olli Hämäläinen |
| Final assessment: | Grading scale (0-5) |
Descriptions
Prerequisites
Programming
Course contents (core content level)
Role of data management in organisations
Data models
Priciples of conceptual analysis
Basic concepts and structures of relational databases
Design of relational databases
Basics of SQL
Use of relational databases in application programmming
Course contents (additional)
Mathematical and logical foundations of relational model
Standardisation
Object paradigm and databases
Core content level learning outcomes (knowledge and understanding)
Knowledge on basic concepts and properties of relational databases
Knowledge on the capabilities of SQL
Knowledge of application techniques that utillise relational databases
General understanding on the properties of MS Access, Oracle, and MySQL systems
Core content level learning outcomes (skills)
Ability to perform the conceptual analysis of a small application area
Ability to design a small database and implement it in MS Access, Oracle, and MySQL
Fluent use of basic features of SQL
Recommended reading
Teaching and learning strategies
Lectures 21 h
Laboratory 21 h
Project assignment 20 h
Self study 16 h
Exam 2 h
Total 80 h
Teaching methods and student workload
Lectures
Exam
Self-study
Laboratory assignments
Assignments
Assessment weighting and grading
Exam 85%, project assignement 15%
Related competences of the degree programme
Information Systems