x !
Arkistoitu opetussuunnitelma 2011–2012
Selaamasi opetussuunnitelma ei ole enää voimassa. Tarkista tiedot voimassa olevasta opetussuunnitelmasta.
TKOPP3 Data Bases 4 op
Organised by
Computer Science
Person in charge
Lecturer.
Preceding studies
Compulsory:
Or corresponding knowledge in the field.

Learning outcomes

The goal is to familiarise students with the basic structures of SQL databases and using ER modelling. Upon completion of the course, students will be able to model data using ER diagrams, convert ER models into SQL database (relational database) schemas, and use a database with the help of SQL language.

Contents

Course topics include establishing a database, updating data and posing queries in SQL language, ER diagrams and conversion from an ER diagram into an SQL database (relational database) schema.

Teaching methods

Teaching method Contact Online
Lectures 14 h 0 h
Exercises 12 h 0 h

Teaching language

Finnish

Modes of study

Written examination, a certain number of weekly exercises and a project work.

Evaluation

Numeric 1-5.

Recommended year of study

1. year autumn

Study materials

  1. Elmasri, R. & Navathe, S., Fundamentals of Database Systems. Benjamin/Cummings, 1997 or newer edition.

Further information

Some of the topics have previously been part of the courses Principles of Information Systems and Database Programming. If you have completed the course Principles of Information Systems, you can take this course. If you have completed the course Database Programming (10 ECTS/5 cu) before autumn 2004, you cannot get credits for this course.

Belongs to following study modules

Informaatiotieteiden yksikkö
Joint Basic Studies (Tietojenkäsittelyoppi)
Informaatiotieteiden yksikkö
Joint Basic Studies (Vuorovaikutteinen teknologia)
2011–2012
Teaching
Archived Teaching Schedule. Please refer to current Teaching Shedule.
Period I Period II Period III Period IV
TKOPP3 Tietokantojen perusteet
Informaatiotieteiden yksikkö