•   Data Systems and Analysis 5G00DM01-3003 02.09.2021-16.12.2021  5 cr  (20I260E) +-
    Learning outcomes of the course unit
    The student learns basic concepts, ideas and principles concerning database systems including big data systems. The student is able to install, configure and run a database system and to design and implement data content to it and handle it with SQL language. General big data system concepts are handled; the aim is that the student can install, configure and run a big data system and handle it’s data. Some of the most popular big data technologies are learned.
    Course contents
    Course content is:
    - General ideas of a database system,
    - Data modelling and design techniques,
    - Relational model, data handling with SQL language,
    - Database programming,
    - NoSQL databases
    - General ideas of a big data system
    - CRISP DM
    Assessment criteria
    Satisfactory

    Student knows database system concepts and ideas and recognises them in real running systems. The student is able to do modest maintenance works for existing database systems and participate partly in the design of new database systems.

    Good

    Student understands database system concepts and ideas and can justify their existence in real running systems. The student is able to maintain existing database system structures and design of new database system parts.

    Excellent

    Student knows and understands in depth database system concepts and ideas and is familiar with their existence in real running systems. The student is able to create new database system structures and make new designs in all areas of the database systems.

    Name of lecturer(s)

    Ossi Nykänen

    Recommended or required reading

    Moodle course with links to additional material.

    Planned learning activities and teaching methods

    Contact teaching
    Assignments (the primary learning method)
    Group work and presentation

    Assessment methods and criteria

    Assignments and group work.

    Language of instruction

    English

    Timing

    02.09.2021 - 16.12.2021

    Registration

    01.06.2021 - 03.10.2021

    Credits

    5 cr

    Group(s)

    20I260E

    Seats

    0 - 40

    Teacher(s)

    Ossi Nykänen

    Further information for students

    Because of the covid situation and the related difficulties in travelling, teamwork sessions of the course are organized (only) remotely, using MS Teams. Session with new topic introductions are organized with both f2f and remote participants in mind. See the Moodle course for instructions how to attend the contact teaching hours.

    Unit, in charge

    ICT Engineering

    Degree programme(s)

    Bachelor's Degree Programme in Software Engineering

    Office

    TAMK Main Campus

    Evaluation scale

    0-5

    Exam schedule

    No exam.

    Students use of time and load

    See the period timetable.

    Assessment criteria
    Not approved

    Less than 30% of the exercises completed.

    Satisfactory

    The student is familiar with data systems basics and can design small databases.
    At least 30% of the exercises completed, and minimal group work completed/presented.

    Good

    The student is familiar with data systems basics and can design and analyze small databases. The student knows the elements of good database design (e.g. normalization and indexing) and can implement small database applications.
    At least 60% of the exercises completed, and good group work completed/presented.

    Excellent

    The student is familiar with data systems basics and can design and analyze small databases. The student is understands the elements of good database design (e.g. normalization and indexing) and can implement small database applications. The student is able to critically evaluate basic applications and database design choices.
    At least 90% of the exercises completed, and excellent group work completed/presented.