Course Catalog 2008-2009 International Basic Pori International Postgraduate Open University |Degrees|     |Study blocks|     |Courses|

Course´s person responsible

Jari Peltonen, Anna Auvinen

Implementations

	Lecture times and places	Target group recommended to
Implementation 1

Requirements

Assignments, exercises and examination.
Completion parts must belong to the same implementation

Principles and baselines related to teaching and learning

-

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.

Evaluation criteria for the course

Examination, grading affected by the assignments and exercises.

Assessment scale:

Numerical evaluation scale (1-5) will be used on the course

Partial passing:

Completion parts must belong to the same implementation

Study material

Type	Name	Author	ISBN	URL	Edition, availability, ...	Examination material	Language
-	Database Systems, A Practical Approach to Design, Implementation, and Management	Connolly, Begg			Third edition or newer.		English

Prerequisites

Correspondence of content

Additional information

The course is meant for students who do not understand Finnish language and the number of participants will be limited to <= 32 students. OHJ-3300 is the corresponding course for native Finnish speaking students.

More precise information per implementation

	Description	Methods of instruction	Implementation
Implementation 1			Contact teaching: 0 % Distance learning: 0 % Self-directed learning: 0 %

Last modified	21.08.2008
Modifier	Anna Auvinen