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