Databases (4cr)
Code: KL04BT50020-3001
General information
- Enrollment
- 30.09.2017 - 10.12.2017
- Registration for the implementation has ended.
- Timing
- 30.10.2017 - 17.12.2017
- Implementation has ended.
- Number of ECTS credits allocated
- 4 cr
- Local portion
- 4 cr
- Mode of delivery
- Contact learning
- Teaching languages
- Finnish
- Seats
- 0 - 35
- Degree programmes
- Bachelor of Engineering, Information Technology
- Teachers
- Markku Lahti
- Course
- KL04BT50020
Evaluation scale
1-5
Content scheduling
The course comprises the following:
- Relational model
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Objective
The aim of the course is to familiarize the student with the basics of data management. The student understands the relational model, relational database and learns the stages of the information analysis. Students will have command of SQL language.
Content
The course comprises the following:
- Relational model
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Materials
Lecture materials,
Additional material: Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison Wesley
Teaching methods
Lectures and exercises
Exam schedules
Exam is at the end of the course
Student workload
104 h, of which scheduled studies 52 h and autonomous studies 52 h
Assessment criteria, satisfactory (1)
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
- Good (3-4): The student masters well the principles of database design and basic of SQL language
- Satisfactory (1-2) The student knows the basics
Qualifications
No previous studies are required.