-- ================================================================ -- SQL for Video Store Sample Database for SQL Demystified. -- -- ==> Updated 27 September, 2005: Changed all dates to -- YYYY-MM-DD Format -- -- ==> This script may require additional modification before -- you can run them on your RDBMS. Known changes for -- popular RDBMS products are as follows: -- -- MySQL: No SQL changes should be required. Use the -- CREATE SCHEMA command to create the database; switch -- to the database with the USE command, and then run -- the script. -- -- Oracle: Use the CREATE USER command to create the user and -- schema, use the GRANT command to grant the user the -- user the CONNECT and RESOURCE privileges; then connect -- connect as the new user. Before running this script, -- run the following command to change the default date -- format to YYYY-MM-DD: -- ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD'; -- -- SQL Server: No changes should be required if you use -- Management Studio is recommended for running the SQL. -- Create the database, Click the New Query button, copy -- and paste the script into the query window, then press -- the Execute button. -- -- NOTE: The DROP TABLE statements will cause errors the first -- time you run the script because the tables will not -- exist, but the statements following them should all run -- correctly. If note, simply remove or comment-out the -- statements. -- -- ================================================================ -- Drop all tables (Only needed if the tables already exist). -- ================================================================ DROP TABLE MOVIE_RENTAL; DROP TABLE CUSTOMER_TRANSACTION; DROP TABLE CUSTOMER_ACCOUNT_PERSON; DROP TABLE CUSTOMER_ACCOUNT; DROP TABLE EMPLOYEE; DROP TABLE MOVIE_LANGUAGE; DROP TABLE LANGUAGE; DROP TABLE MOVIE_COPY; DROP TABLE MOVIE; DROP TABLE MPAA_RATING; DROP TABLE MOVIE_GENRE; DROP TABLE PERSON; -- ======================================================== -- CREATE statements for Video Store Sample Database -- ======================================================== -- ======================================================== -- Table: CUSTOMER_ACCOUNT -- ======================================================== CREATE TABLE CUSTOMER_ACCOUNT ( CUSTOMER_ACCOUNT_ID INTEGER NOT NULL, CUSTOMER_HOLD_INDIC CHAR(1) DEFAULT 'N' NOT NULL CHECK (CUSTOMER_HOLD_INDIC IN ('Y','N')), DATE_ENROLLED DATE NOT NULL, DATE_TERMINATED DATE NULL, CUSTOMER_DEPOSIT_AMOUNT NUMERIC(5,2) NULL, CREDIT_CARD_ON_FILE_INDIC CHAR(1) NOT NULL CHECK (CREDIT_CARD_ON_FILE_INDIC IN ('Y','N')), CHILD_RENTAL_ALLOWED_INDIC CHAR(1) NOT NULL CHECK (CHILD_RENTAL_ALLOWED_INDIC IN ('Y','N')), PRIMARY KEY (CUSTOMER_ACCOUNT_ID) ); -- ======================================================== -- Table: LANGUAGE -- ======================================================== CREATE TABLE LANGUAGE ( LANGUAGE_CODE CHAR(2) NOT NULL, LANGUAGE_NAME VARCHAR(40) NOT NULL, PRIMARY KEY (LANGUAGE_CODE) ); -- ======================================================== -- Table: MOVIE_GENRE -- ======================================================== CREATE TABLE MOVIE_GENRE ( MOVIE_GENRE_CODE CHAR(5) NOT NULL, MOVIE_GENRE_DESCRIPTION VARCHAR(100) NOT NULL, PRIMARY KEY (MOVIE_GENRE_CODE) ); -- ======================================================== -- Table: MPAA_RATING -- ======================================================== CREATE TABLE MPAA_RATING ( MPAA_RATING_CODE CHAR(5) NOT NULL, MPAA_RATING_DESCRIPTION VARCHAR(100) NOT NULL, PRIMARY KEY (MPAA_RATING_CODE) ); -- ======================================================== -- Table: PERSON -- ======================================================== CREATE TABLE PERSON ( PERSON_ID INTEGER NOT NULL, PERSON_GIVEN_NAME VARCHAR(25) NOT NULL, PERSON_MIDDLE_NAME VARCHAR(25) NULL, PERSON_FAMILY_NAME VARCHAR(25) NOT NULL, PERSON_ADDRESS_1 VARCHAR(100) NULL, PERSON_ADDRESS_2 VARCHAR(100) NULL, PERSON_ADDRESS_CITY VARCHAR(40) NULL, PERSON_ADDRESS_STATE_PROV CHAR(2) NULL, PERSON_ADDRESS_POSTAL_CODE VARCHAR(10) NULL, PERSON_ADDRESS_COUNTRY CHAR(2) NULL, PERSON_PHONE VARCHAR(15) NULL, BIRTH_DATE DATE NULL, DEATH_DATE DATE NULL, PRIMARY KEY (PERSON_ID) ); -- ======================================================== -- Table: MOVIE -- ======================================================== CREATE TABLE MOVIE ( MOVIE_ID INTEGER NOT NULL, MOVIE_GENRE_CODE CHAR(5) NOT NULL, MPAA_RATING_CODE CHAR(5) NOT NULL, MOVIE_TITLE VARCHAR(100) NOT NULL, RETAIL_PRICE_VHS NUMERIC(5,2) NULL, RETAIL_PRICE_DVD NUMERIC(5,2) NULL, YEAR_PRODUCED CHAR(4) NULL, PRIMARY KEY (MOVIE_ID), FOREIGN KEY (MOVIE_GENRE_CODE) REFERENCES MOVIE_GENRE (MOVIE_GENRE_CODE), FOREIGN KEY (MPAA_RATING_CODE) REFERENCES MPAA_RATING (MPAA_RATING_CODE) ); -- ======================================================== -- Index: IX_MOVIE_GENRE_MOVIE -- ======================================================== CREATE INDEX IX_MOVIE_GENRE_MOVIE ON MOVIE (MOVIE_GENRE_CODE ASC); -- ======================================================== -- Index: IX_MOVIE_TITLE -- ======================================================== CREATE INDEX IX_MOVIE_TITLE ON MOVIE (MOVIE_TITLE ASC); -- ======================================================== -- Table: MOVIE_COPY -- ======================================================== CREATE TABLE MOVIE_COPY ( MOVIE_ID INTEGER NOT NULL, COPY_NUMBER INTEGER NOT NULL, DATE_ACQUIRED DATE NOT NULL, DATE_SOLD DATE NULL, MEDIA_FORMAT CHAR(1) NOT NULL CHECK (MEDIA_FORMAT IN ('D','V')), PRIMARY KEY (MOVIE_ID, COPY_NUMBER), FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE (MOVIE_ID) ); -- ======================================================== -- Table: MOVIE_LANGUAGE -- ======================================================== CREATE TABLE MOVIE_LANGUAGE ( MOVIE_ID INTEGER NOT NULL, LANGUAGE_CODE CHAR(2) NOT NULL, PRIMARY KEY (MOVIE_ID, LANGUAGE_CODE), FOREIGN KEY (LANGUAGE_CODE) REFERENCES LANGUAGE (LANGUAGE_CODE), FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE (MOVIE_ID) ); -- ======================================================== -- Index: IX_LANG_MOVIE_LANG -- ======================================================== CREATE INDEX IX_LANG_MOVIE_LANG ON MOVIE_LANGUAGE (LANGUAGE_CODE ASC); -- ======================================================== -- Table: EMPLOYEE -- ======================================================== CREATE TABLE EMPLOYEE ( PERSON_ID INTEGER NOT NULL, SUPERVISOR_PERSON_ID INTEGER NULL, EMPLOYEE_TAX_ID VARCHAR(15) NOT NULL, EMPLOYEE_JOB_CATEGORY CHAR(1) NOT NULL CHECK (EMPLOYEE_JOB_CATEGORY IN ('M','C','O')), EMPLOYEE_HOURLY_RATE NUMERIC(5,2) NOT NULL, HIRE_DATE DATE NOT NULL, TERMINATION_DATE DATE NULL, PRIMARY KEY (PERSON_ID), FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID), FOREIGN KEY (SUPERVISOR_PERSON_ID) REFERENCES EMPLOYEE (PERSON_ID) ); -- ======================================================== -- Index: IX_SUPERVISOR_PERSON_ID -- ======================================================== CREATE INDEX IX_SUPERVISOR_PERSON_ID ON EMPLOYEE (SUPERVISOR_PERSON_ID ASC); -- ======================================================== -- Table: CUSTOMER_ACCOUNT_PERSON -- ======================================================== CREATE TABLE CUSTOMER_ACCOUNT_PERSON ( CUSTOMER_ACCOUNT_ID INTEGER NOT NULL, PERSON_ID INTEGER NOT NULL, PRIMARY KEY (CUSTOMER_ACCOUNT_ID, PERSON_ID), FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID), FOREIGN KEY (CUSTOMER_ACCOUNT_ID) REFERENCES CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID) ); -- ======================================================== -- Index: IX_PERSON_CUSTOMER_ACCT_PERSON -- ======================================================== CREATE INDEX IX_PERSON_CUSTOMER_ACCT_PERSON ON CUSTOMER_ACCOUNT_PERSON (PERSON_ID ASC); -- ======================================================== -- Table: CUSTOMER_TRANSACTION -- ======================================================== CREATE TABLE CUSTOMER_TRANSACTION ( TRANSACTION_ID INTEGER NOT NULL, CUSTOMER_ACCOUNT_ID INTEGER NOT NULL, EMPLOYEE_PERSON_ID INTEGER NOT NULL, TRANSACTION_DATE DATE NOT NULL, SALES_TAX NUMERIC(5,2) NOT NULL, PRIMARY KEY (TRANSACTION_ID), FOREIGN KEY (EMPLOYEE_PERSON_ID) REFERENCES EMPLOYEE (PERSON_ID), FOREIGN KEY (CUSTOMER_ACCOUNT_ID) REFERENCES CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID) ); -- ======================================================== -- Index: IX_EMPLOYEE_CUSTOMER_TRANS -- ======================================================== CREATE INDEX IX_EMPLOYEE_CUSTOMER_TRANS ON CUSTOMER_TRANSACTION (EMPLOYEE_PERSON_ID ASC); -- ======================================================== -- Index: IX_CUST_ACCT_CUST_TRANS -- ======================================================== CREATE INDEX IX_CUST_ACCT_CUST_TRANS ON CUSTOMER_TRANSACTION (CUSTOMER_ACCOUNT_ID ASC); -- ======================================================== -- Table: MOVIE_RENTAL -- ======================================================== CREATE TABLE MOVIE_RENTAL ( MOVIE_ID INTEGER NOT NULL, COPY_NUMBER INTEGER NOT NULL, TRANSACTION_ID INTEGER NOT NULL, DUE_DATE DATE NULL, RENTAL_FEE NUMERIC(7,2) NULL, LATE_OR_LOSS_FEE NUMERIC(5,2) NULL, RETURNED_DATE DATE NULL, PRIMARY KEY (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID), FOREIGN KEY (MOVIE_ID, COPY_NUMBER) REFERENCES MOVIE_COPY (MOVIE_ID, COPY_NUMBER), FOREIGN KEY (TRANSACTION_ID) REFERENCES CUSTOMER_TRANSACTION (TRANSACTION_ID) ); -- ======================================================== -- Index: IX_MOVIE_CUST_TRANS -- ======================================================== CREATE INDEX IX_MOVIE_CUST_TRANS ON MOVIE_RENTAL (TRANSACTION_ID ASC); -- ======================================================== -- INSERT statements for Video Store Sample Database -- ======================================================== -- ======================================================= -- Table: CUSTOMER_ACCOUNT -- ======================================================= INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (1, 'N', '2005-01-01', null, null ,'N', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (2, 'N', '2005-01-18', null, null, 'N', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (3, 'N', '2005-02-01', null, null, 'Y', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (4, 'N', '2005-02-01', null, 50, 'N', 'Y'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (5, 'N', '2005-02-01', null, 50, 'N', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (6, 'Y', '2005-02-15', '2005-03-01', null, 'Y', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (7, 'N', '2005-02-15', null, null, 'Y', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (8, 'N', '2005-03-01', null, null, 'Y', 'N'); INSERT INTO CUSTOMER_ACCOUNT (CUSTOMER_ACCOUNT_ID, CUSTOMER_HOLD_INDIC, DATE_ENROLLED, DATE_TERMINATED, CUSTOMER_DEPOSIT_AMOUNT, CREDIT_CARD_ON_FILE_INDIC, CHILD_RENTAL_ALLOWED_INDIC) VALUES (9, 'Y', '2005-03-01', null, 50, 'N', 'N'); -- ======================================================= -- Table: LANGUAGE -- ======================================================= INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('es','Spanish'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('zh','Chinese'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('nl','Dutch'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('en','English'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('fr','French'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('de','German'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('ja','Japanese'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('ru','Russian'); INSERT INTO LANGUAGE (LANGUAGE_CODE, LANGUAGE_NAME) VALUES ('ko','Korean'); -- ======================================================= -- Table: MOVIE_GENRE -- ======================================================= INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('ActAd','Action and Adventure'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Anime','Anime and Animation'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('ChFam','Children and Family'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Class','Classics'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Comdy','Comedy'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Doc','Documentary'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Drama','Drama'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Forgn','Foreign'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Hor','Horror'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Indep','Independent'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Music','Music and Musicals'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Rmce','Romance'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('SciFi','Science Fiction and Fantasy'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Specl','Special Interest'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Sport','Sports'); INSERT INTO MOVIE_GENRE (MOVIE_GENRE_CODE, MOVIE_GENRE_DESCRIPTION) VALUES ('Thril','Thrillers'); -- ======================================================= -- Table: MPAA_RATING -- ======================================================= INSERT INTO MPAA_RATING (MPAA_RATING_CODE, MPAA_RATING_DESCRIPTION) VALUES ('G','General audiences'); INSERT INTO MPAA_RATING (MPAA_RATING_CODE, MPAA_RATING_DESCRIPTION) VALUES ('PG','Parental guidance suggested'); INSERT INTO MPAA_RATING (MPAA_RATING_CODE, MPAA_RATING_DESCRIPTION) VALUES ('PG-13','Parents strongly cautioned'); INSERT INTO MPAA_RATING (MPAA_RATING_CODE, MPAA_RATING_DESCRIPTION) VALUES ('R', 'Under 17 requires accompanying parent or adult guardian'); INSERT INTO MPAA_RATING (MPAA_RATING_CODE, MPAA_RATING_DESCRIPTION) VALUES ('NC-17','No one 17 and under admitted'); INSERT INTO MPAA_RATING (MPAA_RATING_CODE, MPAA_RATING_DESCRIPTION) VALUES ('NR','Not Rated'); -- ======================================================= -- Table: PERSON -- ======================================================= INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (1,'Austin','Byron','Alexander', '420 Central','Apt. 4A', 'Paperwork City', 'CA', '94645', 'US', '805-280-2018', '1970-07-04', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (2,'Tin','Tang','Chung', '3467 Skyline Blvd','Apt. 4583', 'Oakland', 'CA', '94620', 'US', '230-229-8976', '1968-05-05', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (3,'Cassandra','R','Alvarado', '553 Elm St.','', 'Denver', 'CO', '80012', 'US', '836-429-8375', '1981-09-27', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (4,'Raul','Ramon', 'Alvarado', '553 Elm St.','', 'Denver', 'CO', '80012', 'US', '836-429-8375', '1983-08-26', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (5,'Klaus','Jurgen', 'Schmidt', '2920 College Drive','Apt. 12', 'Dayton', 'OH', '45404', 'US', '514-369-0478', '1951-06-20', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (6,'Katarina','C', 'Schmidt', '2920 College Drive','Apt. 12', 'Dayton', 'OH', '45404', 'US', '514-369-0478', '1953-12-15', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (7,'Karl','Jurgen', 'Schmidt', '2920 College Drive','Apt. 12', 'Dayton', 'OH', '45404', 'US', '514-369-0479', '1980-04-16', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (8,'Toshiro','Isuzu', 'Yamada', '720 Geary Blvd.','', 'San Francisco', 'CA', '94111', 'US', '401-617-7297', '1949-03-16', '2005-03-30'); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (9,'Beverly','Virginia', 'Baker', '748 Highway 63','', 'Thunder Bay', 'ON', '4WC2RY', 'CA', '705-555-6376', '1981-02-28', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (10,'Gerald','M', 'Bernstein', '12940 Wilshire Blvd.','', 'Los Angeles', 'CA', '90048', 'US', '820-541-8590', '1959-08-13', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (11,'Rose','Barbara', 'Bernstein', '12940 Wilshire Blvd.','', 'Los Angeles', 'CA', '90048', 'US', '820-541-8590', '1960-04-16', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (12,'Steven','R', 'Bernstein', '12940 Wilshire Blvd.','', 'Los Angeles', 'CA', '90048', 'US', '820-541-8590', '1994-06-17', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (13,'Linda','R', 'Campos', 'Box 426','Rural Route 12', 'Searchlight', 'NV', '89046', 'US', '615-995-1458', '1974-11-15', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (14,'Jorge','Luis', 'Jimenez', 'Box 426','Rural Route 12', 'Searchlight', 'NV', '89046', 'US', '615-995-3748', '1974-12-21', null); INSERT INTO PERSON (PERSON_ID, PERSON_GIVEN_NAME, PERSON_MIDDLE_NAME, PERSON_FAMILY_NAME, PERSON_ADDRESS_1, PERSON_ADDRESS_2, PERSON_ADDRESS_CITY, PERSON_ADDRESS_STATE_PROV, PERSON_ADDRESS_POSTAL_CODE, PERSON_ADDRESS_COUNTRY, PERSON_PHONE, BIRTH_DATE, DEATH_DATE) VALUES (15,'Liyi','F', 'Huang', '228 1st St. NE','', 'St. Paul', 'MN', '55111', 'US', '708-668-6696', '1976-05-14', null); -- ======================================================= -- Table: MOVIE -- ======================================================= INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (1, 'Drama', 'R', 'Mystic River', 58.97, 19.96, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (2, 'ActAd', 'R', 'The Last Samurai', 15.95, 19.96, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (3, 'Comdy', 'PG-13', 'Something''s Gotta Give', 14.95, 29.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (4, 'ActAd', 'PG-13', 'The Italian Job', 11.95, 19.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (5, 'ActAd', 'R', 'Kill Bill: Vol. 1', 24.99, 29.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (6, 'ActAd', 'PG-13', 'Pirates of the Caribbean: The Curse of the Black Pearl', 24.99, 29.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (7, 'Drama', 'PG-13', 'Big Fish', 14.95, 19.94, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (8, 'ActAd', 'R', 'Man on Fire', 50.99, 29.98, '2004'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (9, 'ActAd', 'PG-13', 'Master and Commander: The Far Side of the World', 12.98, 39.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (10, 'Drama', 'R', 'Lost in Translation', 49.99, 14.98, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (11, 'Rmce', 'PG-13', 'Two Weeks Notice', 6.93, 14.97, '2002'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (12, 'Comdy', 'PG-13', '50 First Dates', 9.95, 19.94, '2004'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (13, 'Comdy', 'PG-13', 'Matchstick Men', 6.93, 19.97, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (14, 'Drama', 'R', 'Cold Mountain', 24.99, 29.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (15, 'Drama', 'R', 'Road to Perdition', 9.99, 14.99, '2002'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (16, 'Comdy', 'PG-13', 'The School of Rock', 11.69, 29.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (17, 'Rmce', 'PG-13', '13 Going on 30', 14.94, 28.95, '2004'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (18, 'Drama', 'R', 'Monster', 24.99, 29.99, '2003'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (19, 'ActAd', 'PG-13', 'The Day After Tomorrow', 12.98, 29.98, '2004'); INSERT INTO MOVIE (MOVIE_ID, MOVIE_GENRE_CODE, MPAA_RATING_CODE, MOVIE_TITLE, RETAIL_PRICE_VHS, RETAIL_PRICE_DVD, YEAR_PRODUCED) VALUES (20, 'Forgn', 'R', 'Das Boot', 17.99, 19.94, '1981'); -- ======================================================= -- Table: MOVIE_COPY -- ======================================================= INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (1, 1, '2005-01-01', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (2, 1, '2005-01-10', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (2, 2, '2005-01-01', null, 'V'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (3, 1, '2005-01-01', '2005-01-30', 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (3, 2, '2005-02-15', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (4, 1, '2005-02-15', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (5, 1, '2005-02-15', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (5, 2, '2005-02-15', null, 'V'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (6, 1, '2005-02-15', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (7, 1, '2005-02-28', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (8, 1, '2005-02-28', '2005-03-15', 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (9, 1, '2005-02-28', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (10, 1, '2005-03-01', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (10, 2, '2005-03-01', null, 'V'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (11, 1, '2005-03-10', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (12, 1, '2005-03-10', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (13, 1, '2005-03-10', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (14, 1, '2005-03-10', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (14, 2, '2005-03-10', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (15, 1, '2005-04-01', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (16, 1, '2005-04-01', null, 'V'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (17, 1, '2005-04-01', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (18, 1, '2005-04-01', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (19, 1, '2005-04-01', null, 'D'); INSERT INTO MOVIE_COPY (MOVIE_ID, COPY_NUMBER, DATE_ACQUIRED, DATE_SOLD, MEDIA_FORMAT) VALUES (20, 1, '2005-04-15', '2005-04-15', 'V'); -- ======================================================= -- Table: MOVIE_LANGUAGE -- ======================================================= INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (1, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (1, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (2, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (2, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (3, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (3, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (4, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (4, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (5, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (5, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (6, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (6, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (7, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (7, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (8, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (8, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (9, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (9, 'es'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (9, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (10, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (10, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (11, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (11, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (12, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (12, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (13, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (13, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (14, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (15, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (15, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (16, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (16, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (17, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (18, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (19, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (19, 'es'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (19, 'fr'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (20, 'de'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (20, 'en'); INSERT INTO MOVIE_LANGUAGE (MOVIE_ID, LANGUAGE_CODE) VALUES (20, 'fr'); -- ======================================================= -- Table: EMPLOYEE -- ======================================================= INSERT INTO EMPLOYEE (PERSON_ID, SUPERVISOR_PERSON_ID, EMPLOYEE_TAX_ID, EMPLOYEE_JOB_CATEGORY, EMPLOYEE_HOURLY_RATE, HIRE_DATE, TERMINATION_DATE) VALUES (1, null, '000-01-1234', 'M', 15.00, '2004-01-01', null); INSERT INTO EMPLOYEE (PERSON_ID, SUPERVISOR_PERSON_ID, EMPLOYEE_TAX_ID, EMPLOYEE_JOB_CATEGORY, EMPLOYEE_HOURLY_RATE, HIRE_DATE, TERMINATION_DATE) VALUES (2, 1, '000-02-8564', 'C', 9.75, '2004-01-01', null); INSERT INTO EMPLOYEE (PERSON_ID, SUPERVISOR_PERSON_ID, EMPLOYEE_TAX_ID, EMPLOYEE_JOB_CATEGORY, EMPLOYEE_HOURLY_RATE, HIRE_DATE, TERMINATION_DATE) VALUES (10, 1, '000-57-8385', 'C', 9.75, '2004-03-01', null); -- ======================================================= -- Table: CUSTOMER_ACCOUNT_PERSON -- ======================================================= INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (1, 1); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (2, 2); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (3, 3); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (3, 4); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (3, 7); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (4, 5); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (4, 6); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (4, 7); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (5, 8); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (6, 9); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (7, 10); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (7, 11); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (7, 12); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (8, 13); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (8, 14); INSERT INTO CUSTOMER_ACCOUNT_PERSON (CUSTOMER_ACCOUNT_ID, PERSON_ID) VALUES (9, 15); -- ======================================================= -- Table: CUSTOMER_TRANSACTION -- ======================================================= INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (1, 1, 1, '2005-01-05', 1.00); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (2, 1, 1, '2005-01-05', 2.97); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (3, 2, 2, '2005-01-18', 1.50); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (4, 3, 1, '2005-02-01', 0.50); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (5, 4, 2, '2005-02-01', 1.00); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (6, 6, 2, '2005-02-15', 0.50); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (7, 7, 1, '2005-02-15', 1.00); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (8, 7, 1, '2005-02-23', 1.50); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (9, 8, 10, '2005-03-01', 3.51); INSERT INTO CUSTOMER_TRANSACTION (TRANSACTION_ID, CUSTOMER_ACCOUNT_ID, EMPLOYEE_PERSON_ID, TRANSACTION_DATE, SALES_TAX) VALUES (10, 9, 10, '2005-03-01', 2.08); -- ======================================================= -- Table: MOVIE_RENTAL -- ======================================================= INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (1, 1, 1, '2005-01-09', 6.00, null, '2005-01-07'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (2, 2, 1, '2005-01-09', 6.00, null, '2005-01-08'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (3, 1, 2, '2005-01-09', 6.00, 29.99, '2005-01-30'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (1, 1, 3, '2005-01-22', 6.00, null, '2005-01-22'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (2, 1, 3, '2005-01-22', 6, null,'2005-01-18'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (2, 2, 3, '2005-01-22', 6, null, '2005-01-20'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (1, 1, 4, '2005-02-05', 6, null, '2005-02-04'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (2, 1, 5, '2005-02-05', 6, 4, '2005-02-08'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (5, 2, 6, '2005-02-19', 6, null, null); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (6, 1, 7, '2005-02-19', 6, null, '2005-02-19'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (16, 1, 7, '2005-02-19', 6, null, '2005-02-19'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (1, 1, 8, '2005-02-27', 6, 4, '2005-03-01'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (2, 2, 8, '2005-02-27', 6, null, null); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (5, 1, 8, '2005-02-27', 6, null, null); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (10, 1, 9, '2005-03-04', 6.25, null, null); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (8, 1, 9, '2005-03-04', 6.25, 29.98, '2005-03-15'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (4, 1, 10, '2005-03-04', 6.25, null, '2005-03-04'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (18, 1, 10, '2005-03-04', 6.25, null, '2005-03-05'); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (3, 2, 10, '2005-03-04', 6.25, null, null); INSERT INTO MOVIE_RENTAL (MOVIE_ID, COPY_NUMBER, TRANSACTION_ID, DUE_DATE, RENTAL_FEE, LATE_OR_LOSS_FEE, RETURNED_DATE) VALUES (17, 1, 10, '2005-03-04', 6.25, null, null);