Back to the site

Information Technology and Digital Banking: Concepts and Practice · Part B: Systems and Design

Chapter 7: Databases and SQL

Where a bank’s data lives: database systems, the relational model and keys, normalisation, SQL and transactions, and the backups that let a bank recover.

Open Chapter 7 in the e-bookThe book and its prices

Buyers of the e-book, or of the print copy, which includes it, read the whole chapter. Everyone can read the free sample, pages 1 to 24 of the e-book.

About this chapter

In the exam

Expect DBMS terms, keys, integrity rules, normal forms and anomalies, SQL command groups, ACID, Oracle and backups.

At the desk: The vanished debit, Bank N

A customer complains that a transfer “disappeared”: the server crashed mid-way, and when it came back, the debit to his account was gone. The IS auditors, meanwhile, find branch addresses copied into every customer record.

Mr Arvind Menon asks Mr Rohit Deshpande to explain both to the operations committee, and to settle the backup plan for the loan database.

In this chapter

Corrections and updates

None for this chapter so far. Every correction to the book, and any rule that changes after its date, is listed on the errata page.