O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

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

Your Momma Loves Drama Database

The YMLD database was introduced earlier in the SQL chapter of the book. For reference, the database schema is reproduced in Figure 11-1.

Figure 11-1. Your Momma Loves Drama schema

More details about the design of each of these tables are provided in the sections that follow.

PRODUCTIONS Table

YMLD is a very small and personal theater with a total of 20 seats. The theater runs a number of productions during the year. These productions are found in the PRODUCTIONS table.

 CREATE TABLE Productions ( Production_No INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, Production_Title VARCHAR(256), Production_Start ...

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