Database Design and Implementation

The best way to understand data type selection is to design a database and implement the design using DB2. We will create a database that can be used to schedule and track the results of a certification program. This database will be used to illustrate many aspects of SQL and features of DB2. You have already seen many examples from this database throughout this chapter. This database will be used to schedule test candidates' exams, and following the completion of the test, it will contain the candidates' test scores. The database and its application will need to perform the following tasks:

Insert/update/delete testing center information.
Insert/update/delete test information.
Insert/update/delete test ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide 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.