Appendix D

Case Studies

D.1 INTRODUCTION

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. ...

Get Introduction to Database Management Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.