O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 the SQL language 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:

  1. Insert/update/delete testing center information.

  2. Insert/update/delete test information.

  3. Insert/update/delete ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required