About the data

1 Setting the scene

1.1 Introduction

Onde upon a time, there was a bank offering services to private persons. The services include managing of accounts, offerings loans, etc.

1.2 Task descripion

The bank wants to improve their services. For instance, the bank managers have only vague idea, who is a good client (whom to offer some additional services) and who is a bad client (whom to watch carefully to monimize the bank loses).

Fortunately, the bank stores data about their clients, the accounts (transactions within several months), the loans already granted, the credit cards issued.

The bank managers hope to improve their undestanding of customers and seed specific actions to improve services. A mere application of discovery tool will not be convincing for them.

1.3 Data description

This database was prepared by Petr Berka and Marta Sochorova.

Simplified logical data model of Berka Bank.

---

2 About the Czech bank database

Data from a real Czech bank. From 1999.

The data about the clients and their accounts consist of following relations:

• relation account (4500 objects in the file ACCOUNT.ASC) - each record describes static characteristics of an account,

• relation client (5369 objects in the file CLIENT.ASC) - each record describes characteristics of a client,

• relation disposition (5369 objects in the file DISP.ASC) - each record relates together a client with an account i.e. this relation describes the rights of clients to operate accounts,

• relation permanent order (6471 objects in the file ORDER.ASC) - each record describes characteristics of a payment order,

• relation transaction (1056320 objects in the file TRANS.ASC) - each record describes one transaction on an account,

• relation loan (682 objects in the file LOAN.ASC) - each record describes a loan granted for a given account,

• relation credit card (892 objects in the file CARD.ASC) - each record describes a credit card issued to an account,

• relation demographic data (77 objects in the file DISTRICT.ASC) - each record describes demographic characteristics of a district.

Each account has both static characteristics (e.g. date of creation, address of the branch) given in relation “account” and dynamic characteristics (e.g. payments debited or credited, balances) given in relations “permanent order” and “transaction”. Relation “client” describes characteristics of persons who can manipulate with the accounts. One client can have more accounts, more clients can manipulate with single account; clients and accounts are related together in relation “disposition”. Relations “loan” and “credit card” describe some services which the bank offers to its clients; more credit cards can be issued to an account, at most one loan can be granted for an account. Relation “demographic data” gives some publicly available information about the districts (e.g. the unemployment rate); additional information about the clients can be deduced from this.

Source: This database was prepared by Petr Berka and Marta Sochorova.