In this appendix, we shall examine several case studies to cement our understanding of various DBMS concepts. We shall take up two sets of topics for discussion.
- One is related to the aspects of database design. We have discussed database design in depth, with detailed coverage of the important concept of normalisation. We shall consider some database structures and see whether they fit these discussions, and if not, how we can modify them suitably.
- The other is related to programming examples. We shall consider a few programs that utilise the various concepts in DBMS technology. The primary concept in DBMS programming is the usage of cursors. This is especially used very widely in IBM mainframe applications. ...