Databases (5 cr)
Code: 5051264-3003
General information
- Enrollment
- 01.08.2021 - 30.08.2021
- Registration for the implementation has ended.
- Timing
- 31.08.2021 - 31.12.2021
- Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- Engineering and Business
- Teaching languages
- Finnish
Evaluation scale
H-5
Content scheduling
Using a database (QBE, SQL)
Planning and implementing a database (entity analysis, ER model, DB structure model, populating a database)
Objective
After completing the course the student is able to:
- understand different types of databases and evaluate their feasibility for different purposes.
- plan and implement a database based on requirements and search and modify data in the database
- use at least one well-known database management system
- describe database management tasks
Content
- Different types of databases
- Definition, planning and implementation of databases
- SQL basics
- Database administration with DBMS
- Management principles for databases
Materials
course material in itslearning
Teaching methods
learning by doing
Pedagogic approaches and sustainable development
Weekly topics are handled with
- lecture
- examples
- assessed network exercises
- db excercise
Completion alternatives
The complete course can be completed with an exam. The date will be agreed upon during the first lesson.
Student workload
lessons and rehearsals 45h
assessed network exercises 45h
DB exercises 45h
Evaluation methods and criteria
Every exercise is worth 5 points, max 100
Points are cumulative and have no weight.
Only exercises returned in time are evaluated.
Failed (0)
< 40% or ( 40/100 points)
Assessment criteria, satisfactory (1-2)
40 - 59%
Assessment criteria, good (3-4)
60 - 79%
Assessment criteria, excellent (5)
>80%
>90% grade5 and 6 credits