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.
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
- 7.1Database management systemsp. 87
- 7.2The relational model and keysp. 88
- 7.3Normalisationp. 89
- 7.4SQL and transactionsp. 90
- 7.5Products, backup and recoveryp. 91
- Exam traps and quick checksp. 92
- Practice: 16 questions in three roundsp. 93
- Answers, with every wrong option explainedp. 95
- Make it stickp. 97
- Chapter 7 on one pagep. 98
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.