TKOPP3 Data Bases, 4 ECTS – Department of Computer Sciences

Student's Guide | Curricula Guides | Teaching Schedules | Suomeksi

Tampere University:

Curricula Guides 2009–2010

Archived Curricula Guide 2008–2010

Curricula Guide is archieved. Please refer to current Curricula Guides

▪ Curricula Guides » Faculty of Information Sciences 2008–2010 » Department of Computer Sciences » Joint Basic Studies

TKOPP3 Data Bases 4 ECTS

Course homepage

Organised by

Computer Science

Person in charge

Lecturer.

Planned organizing times

Period(s)	I	II	III	IV
2008–2009		X	X

Preceding studies

Compulsory:

TKOPY4 Introduction to Computing

Or corresponding knowledge in the field.

Belongs to following study modules

Teaching

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.

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

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.