Tietokannat (5 cr)
Code: TTZC0800-0K0V1
General information
- Timing
-
01.01.2020 - 31.07.2020
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Face-to-face
- Unit
- School of Technology
- Teaching languages
- Finnish
- Degree programmes
- Bachelor's Degree Programme in Information and Communications Technology
Evaluation scale
0-5
Objective
The student is familiar with the basic concepts of databases, understands the overall structure and operating principle of a database system, is able to read and draw up database descriptions, is able to create a database, is able to use it (retrieve information from a database) and knows the basics of SQL.
Content
- Introduction to databases
- Database design with conceptual analysis
- Queries and SQL
- Database implementation: tables and relations
Materials
Online learning material (in html/css and pdf format)
Completion alternatives
Exam, assignment, exercises in the learning environment, seminar presentation and self-assessment (learning diary) 100%
Student workload
o lectures 28 h o exercises 27 ho assignment and seminar presentation 40 ho independent work, virtual study, exam 40 hTotal 135 h
Assessment criteria, satisfactory (1)
Sufficient 1: The student is able to design and implement a simple database by creating at least one relationship between tables using primary and foreign keys. In addition, the student is able to make basic SQL queries.
Satisfactory 2: The student is able to design and implement a database and is able to carry out basic queries utilizing SQL. The required documentation contain at least the database description.
Assessment criteria, good (3)
Good 3: The database completed as assignment and in the exam has been designed and implemented almost perfectly and the student knows SQL in a versatile manner. The required documentation is extensive and the assignment has been presented.
Very good 4: The student is able to design and implement a database where the choices are well-founded. He (she) knows the basic commands of SQL comprehensively. The required documentation is extensive and the presentation on the course assignment is fluent.
Assessment criteria, excellent (5)
Excellent 5: The student is able to design and implement an innovative database where the choices are well-founded and metadata is saved. The student can use SQL (Structured Query Language) for demanding data queries. The required documents are complete, understandable and of high quality (error-free). The presentation on the course assignment is extensive.
Qualifications
-
Further information
The assignment is carried out as group work (suggested size 3 persons)