Course Catalog 2007-2008

OHJ-3306 INTRODUCTION TO DATABASES, 3 cr
Introduction to Databases

Courses persons responsible
Jari Peltonen

Lecturers
N.N.

Implementations
  Period 1 Period 2 Period 3 Period 4 Period 5 Summer
Lecture - - - - 4 h/week -
Exercise - - - - 3 h/week -
Exam  
(Timetable for academic year 2007-2008)

Objectives
The student will understand the basics of databases and database systems. They know the used terminology, know how to use a dbms, create a database, and make non-trivial database queries by using SQL.

Content
Content Core content Complementary knowledge Specialist knowledge
1. Concepts, like database, dbms, database system, transaction, etc.  Understanding transactions more deeply  Setting up and management of dbms. 
2. Relational model, the basics of relational databases.  Programmatical database querying and manipulation. The architectures and implementation of database systems.  Special areas, like central memory databases, spatial databases, multimedia databases, etc. 
3. Querying information from a relational database. SQl-language.  Different kinds of database systems, data models, application areas, and implementation possibilities.    
4.   Database management, security, performance, etc.    
5.   Design and implementation of databases and database systems.    

Requirements for completing the course
Assignments, exercises and examination.

Evaluation criteria for the course

  • Examination, grading affected by the assignments and exercises.

  • Used assessment scale is numeric (1-5)

  • Prerequisites
    Code Course Credits M/R
    OHJ-1016 OHJ-1016 Computer Literacy 4 Mandatory
    OHJ-1106 OHJ-1106 Programming I 4 Recommendable

    Prequisite relations (Sign up to TUT Intranet required)

    Remarks

  • Partial passing of course must be in connection with the same round of implementation.

  • Distance learning

  • ITC utilized during the course

  • - In information distribution via homepage, newsgroups or mailing lists, e.g. current issues, timetables
    - In compiling exercise, group or laboratory work
    - In distributing and/or returning exercise work, material etc
    - In interaction and discussion, such as online discussions, chat

    Scaling
    Methods of instructionHours
    Lectures 50
    Exercises 30

    Other scaledHours
    Exam/midterm exam 3
    Total sum 83

    Additional information related to course
    The number of participants will be limited to <= 32 students.

    Correspondence of content
    OHJ-3300 Introduction to Databases

    Course homepage

    Last modified 28.01.2007
    Modified byJari Peltonen