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 ...

Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ 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.