Contents

Preface : The Reluctant Programmer v
1 Systems Architecture 1
Multi-tier Applications 3
2 Data Modelling 18
Entities and Attributes 20
Relationships between Entities 24
Referential Integrity 28
Normalisation 30
3 The Physical Data Model 38
Table and Columns 39
Indexes 40
Database Object Hierarchy 44
4 Introduction to SQL 50
Data Manipulation Language 51
Basic Select Statement 54
Functions 61
Join Multiple Tables 64
Null Values 67
Insert, Update and Delete 68
5 Developing Applications 73
Computer Program 75
Programming Concepts 80
Integrated Development Environment 84
6 Introduction to Objects 90
Object Oriented Programming 97
Persistence 101
7 The Development Process 104
The SDLC Process 105
The Iterative Process 110
The Unified Process 114
8 Quality Standards and Contracts 121
What is Customer Satisfaction ? 122
Quality Systems 127
Contracts 129
9 Packaged Applications 137
ERP – Enterprise Resource Planning 139
ERP Implementation 144
Change Management 150
Non ERP Packaged Software 152
SaaS : Software as a Service 153
10 Web 2.0 : Perspectives & Potentials 157
Deconstructing the Corporation 161
Strategy : Wisdom of the Crowd 165
Technology List : In Perpetual Beta 166
Appendix A : Practice SQL with Zoho DB 169
Appendix B : Cloud Computing with Zoho Creator 184
Requirements & Technical Specifications 184
Building the Application 185
Deploying the Application 195
Glossary 200