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.

Contents

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

Finnish

Evaluation

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