Tietokannat (5 cr)

Evaluation scale

H-5

Content scheduling

Weekly meetings in the computer class room between weeks 2-16.
Topics:
- DBMS and DB use (relational and document databases)
- Basics of SQL
- Data modeling with ER
- Database normalization
- Introduction to document databases

Objective

After completing the course the student can:
- 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

Lecture slides
Supporting material:
Connolly, Thomas M.; Begg, Carolyn E. - Database Systems: A Practical Approach to Design, Implementation and Management - 4. edition or later
Vaish, Gaurav: Getting Started with NoSQL. Packt Publishing Ltd 2013. Check Ebrary for online version

Teaching methods

The course consists of exercises, which are mainly SQL queries. Exercises are divided into weekly topics.
These are practiced both individually and with the teacher help in the computer class room.
Each session begins with an introduction to the topic of the week, which includes examples and lecture slides.
In addition, students design a small database in a group of two students.

Exam schedules

The exam is performed in Ville system.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium premises where Internet use is not allowed. E-exams are open the rest of the year.

Pedagogic approaches and sustainable development

Learning by doing, trial-error, listening and collaborating with peers.

Completion alternatives

Participation in the class room teaching is highly recommended, but not compulsory, which allows working remotely.

Student workload

Participating weekly in the computer classroom 30h
Individual work for exercises 70h
Group work 15h
Exam and preparation 15h

Evaluation methods and criteria

Graded 0-5.
In order to get a grade from the course, the student needs to pass the exam, exercises and group work with adequate points. Each exercise is value of one point. (The total amount of points will be refined in the beginning of the course)
Grading:
Exercises 50% (class room exercises 50%, home work exercises 50%)
Exam 50%
= 100%

Further information

We need a DBMS environment for practical training (UwAmp / MySQL / MariaDB), which needs installation on the personal computer, USB memory stick (mobility between school and home), and/or on the personal profile in TUAS domain (computer class room).
In addition, we use mlab.com or similar online tool for practicing document databases.