Contents


Preface
The Reluctant Programmer v
Preface to the Second Edition ix
Chapter 1 :  Systems Architecture – 1
Multi-tier Applications 4
Chapter 2 : Data Modelling – 19
Entities and Attributes 21
Relationships between Entities 26
Referential Integrity 30
Normalisation 32
Chapter 3 : The Physical Data Model – 42
Table and Columns 43
Indexes 45
Database Object Hierarchy 49
Chapter 4 : Introduction to SQL – 56
Data Manipulation Language 57
Basic Select Statement 60
Functions 68
Join Multiple Tables 72
Null Values 75
Insert, Update and Delete 76
Chapter 5 : Developing Applications – 81
Computer Program 83
Programming Concepts 88
Integrated Development Environment 93
Chapter 6 : The Development Process – 100
The SDLC Process 101
The Iterative Process 106
The Unified Process 111
Chapter 7 : Quality Standards and Contracts – 119
What is Customer Satisfaction? 120
Quality Systems 126
Contracts 128
Chapter 8 : Packaged Applications – 137
ERP – Enterprise Resource Planning 140
ERP Implementation 144
Change Management 151
Non ERP Packaged Software 153
SaaS : Software as a Service 155
Chapter 9 : Data Warehousing – 159
Dimensional Data Model 163
Historical Data 163
Chapter 10 : Web Based Applications – 166
Domain Names 168
Web Hosting Services 173
Web Application Installer 175
Chapter 11 : The Mobile Internet – 178
Platforms 179
Applications (“Apps”) 182
Network 184
Chapter 12 : Web 2.0 and Social Media – 187
Deconstructing the Corporation 191
Social Networking 195
“The web is Us/ing Us” 196
The womb of futurity 198
Appendix : Tutorials – 199
# 1 Build a Blog 199
# 2 Practise SQL with Zoho DB 199
# 3 Build a Cloud Application with Zoho Creator 199
# 4 Implement a Packaged Application on the Web 199


Free Download !

The full text of the book is available for download at this URL. Since the book has been published under Creative Commons, the download is free and there are no obligations. However the author requests that you please consider making donation of US$ 2 only. This is less than the cost of movie ticket in a multiplex but by making this payment you acknowledge the effort that has gone into creating this piece of intellectual property. The author accepts donations through the simple and secure platform of Paypal ( that unfortunately charges US$ 0,35 for the transaction )

%d bloggers like this: