x !
Archived Curricula Guide 2011–2012
Curricula Guide is archieved. Please refer to current Curricula Guides
TKOPA211 Design of Information Systems and Databases 10 ECTS
Organised by
Computer Science
Preceding studies

Learning outcomes

The aim is to provide an overview of the design of a large information system and the design of the databases of an organisation. The emphasis is on information requirements analysis and specification, and on database analysis, definition and design conducted on the basis of information requirements.


Information, data and knowledge. Terminology concerning information and different systems of abstraction levels applied in the design of information systems. Enterprise Architecture. The identification and description of the target area of an information system. Communication in an organisation, its theory and applications. Use of business rules as the basis and method of design. The analysis and definition of the information requirements of an organisation, and database analysis, definition and design based on them: theory, methods and tools. Users' views and their integration. Basics of Concept D language. Enhanced ER model. Object-role model. UML class diagrams. The use of a relational model as a tool. From relational models to object models. The use of an object model as a tool. The organisation of a database project.

Teaching methods

Teaching method Contact Online
Lectures 52 h 0 h
Exercises 26 h 0 h

Teaching language


Modes of study


Numeric 1-5.

Recommended year of study

3. year spring

Study materials

Only selected parts of the books will be dealt with. These parts will be announced separately.

  1. von Halle, B., Business Rules Applied - Building Better Systems Using the Business Rules Approach. Wiley, New York 2002;
  2. Ross, R. G., Principles of the Business Rule Approach. Addison-Wesley 2003;
  3. Schekkerman, J., How to survive in the Jungle of Enterprise Architecture Frameworks. Trafford, Canada 2003;
  4. Halpin, T., Information Modeling and Relational Databases. From Conceptual Analysis to Logical Design. The Morgan Kaufmann Series in Data Management Systems. Morgan Kaufmann 2001.

Additional reading:

  1. Elmasri, R. & Navathe, S.: Fundamentals of Database Systems. Benjamin/ Cummings, painokset 3 tai 4
  2. Inmon, W. H.: Building the Data Warehouse (2. ed.). Wiley, 1996.

Belongs to following study modules

School of Information Sciences
School of Information Sciences
Archived Teaching Schedule. Please refer to current Teaching Shedule.
School of Information Sciences