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:
Insert/update/delete testing center information.
Insert/update/delete test information.