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