LISTING 1: Code to Define Magazine Subscription Table and Sample Data

BEGIN CALLOUT A
CREATE TABLE magazine_subs (
  subscriber_name varchar(30) NOT NULL,
  magazine_name varchar(30) NOT NULL,
  subscription_start datetime NOT NULL,
  subscription_end datetime NOT NULL,
  CONSTRAINT pk_magazine_subs PRIMARY KEY (subscriber_name, magazine_name, 
subscription_start),
CONSTRAINT chk_magazine_subs CHECK (subscription_start <= subscription_end))
END CALLOUT A

BEGIN CALLOUT B
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Andrea', 'Cat Fancy', '1994-03-07', '1997-03-07')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Andrea', 'Cat Fancy', '1997-03-07', '2000-03-07')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Andrea', 'Poodle Patrol', '1997-01-10', '2000-01-10')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Phil', 'Car and Driver', '1990-10-01', '1991-10-01')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Phil', 'Car and Driver', '1997-07-01', '1998-07-01')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Phil', 'Car and Driver', '1998-07-01', '1999-07-01')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Phil', 'Car and Driver', '1999-07-01', '2000-07-01')
INSERT magazine_subs (subscriber_name, magazine_name, subscription_start, 
subscription_end)
VALUES ('Phil', 'Car and Driver', '2000-07-01', '2001-07-01')
END CALLOUT B

BEGIN CALLOUT C
subscriber_name magazine_name   subscription_start subscription_end
--------------- --------------- ------------------ ----------------
Andrea          Cat Fancy       Mar  7 1994        Mar  7 1997
Andrea          Cat Fancy       Mar  7 1997        Mar  7 2000
Andrea          Poodle Patrol   Jan 10 1997        Jan 10 2000
Phil            Car and Driver  Oct  1 1990        Oct  1 1991
Phil            Car and Driver  Jul  1 1997        Jul  1 1998
Phil            Car and Driver  Jul  1 1998        Jul  1 1999
Phil            Car and Driver  Jul  1 1999        Jul  1 2000
Phil            Car and Driver  Jul  1 2000        Jul  1 2001
END CALLOUT C