There are several ways to install the Library sample database with the OpenOffice BASE desktop RDBMS. The easiest one is to download the fully populated database file library.odp from the book's support sites at www.wrox.com or www.agilitator.com.
Alternatively, you may want to run scripts to create the database structure and populate it with data. Here is a step-by-step procedure to install the Library database through SQL scripts. Keep in mind that the purpose of OpenOffice is to hide as much complexity as possible from the users, so it is not as tuned to manipulating raw SQL as full-fledged RDBMSs such as Oracle or Microsoft SQL Server. Please refer to Appendix C for an overview of the OpenOffice.org SQL facilities.