logotipo

Reporte de abusos
img_google

Los objetos con los que se trabajará en este curso son:

Base de datos Composer:

REM
REM Create the tables used by the COMPOSER application in 
REM "Developing Oracle Forms Applications"
REM
PROMPT
PROMPT Create the tables used by the COMPOSER application.
PROMPT 

CREATE TABLE COMPOSER (
COMP_ID NUMBER CONSTRAINT comp_pk PRIMARY KEY,
NAME VARCHAR2(40),
DOB VARCHAR2(10),
DOD VARCHAR2(10),
NATIONALITY VARCHAR2(20),
BIOGRAPHY LONG RAW 
);
INSERT INTO COMPOSER VALUES ('216','Franz Liszt','1811','1886','Hungarian',NULL); 
INSERT INTO COMPOSER VALUES ('220','Nicolo Paganini','1782','1840','Italian',NULL); 
INSERT INTO COMPOSER VALUES ('223','Ludvig Van Beethoven','1770','1827','German',NULL); 
INSERT INTO COMPOSER VALUES ('226','Volfgang Amadeus Mozart','1756','1791','Austrian',NULL); 
INSERT INTO COMPOSER VALUES ('208','Frederic Chopin','1810','1849','Polish/French',NULL); 
INSERT INTO COMPOSER VALUES ('205','Leonard Bernstein','1918','1989','American',NULL); 
COMMIT;

CREATE TABLE WORK (
COMP_ID NUMBER,
WORK_ID NUMBER,
TITLE VARCHAR2(60),
LISTING VARCHAR2(50),
YEAR VARCHAR2(10),
WORK LONG RAW,
CONSTRAINT work_pk PRIMARY KEY (comp_id, work_id),
CONSTRAINT work_comp_id_fk FOREIGN KEY (comp_id)
REFERENCES COMPOSER
ON DELETE CASCADE
);
INSERT INTO WORK VALUES ('220','221','Violin Concerto No. 1','Op. 6','',NULL); 
INSERT INTO WORK VALUES ('220','222','Violin Concerto No. 2','Op. 6','1810',NULL); 
INSERT INTO WORK VALUES ('223','224','Symphony No. 3','Op. 55','1804',NULL); 
INSERT INTO WORK VALUES ('223','225','Piano Concerto No. 5','Op. 73','1811',NULL); 
INSERT INTO WORK VALUES ('226','227','Simphony No. 40','KV 550','1788',NULL); 
INSERT INTO WORK VALUES ('226','228','Simphony No. 41 (Jupiter)','KV 551','1788',NULL); 
INSERT INTO WORK VALUES ('208','211','Ballade No. 3','Op. 33, No. 2','1841',NULL); 
INSERT INTO WORK VALUES ('208','212','Mazurka in D','Op. 4','1841',NULL); 
INSERT INTO WORK VALUES ('216','217','Variations on a Theme by Paganini','Etude No. 3 (La Campanella)','1851',NULL); 
INSERT INTO WORK VALUES ('216','218','Hungarian Rhapsodie No. 13','','1853',NULL); 
INSERT INTO WORK VALUES ('216','219','Hungarian Rhapsodie No. 14','','1853',NULL); 
INSERT INTO WORK VALUES ('208','210','Piano Concerto No. 2','Op. 22','1831',NULL); 
INSERT INTO WORK VALUES ('205','206','West Side Story (Soundtrack)','','1965',NULL); 
INSERT INTO WORK VALUES ('205','207','On the Waterfront (Soundtrack)','','1954',NULL); 
INSERT INTO WORK VALUES ('208','209','Piano Concerto No. 1','Op. 11','1830',NULL); 
COMMIT;

Base de datos ETS

REM
REM Create the tables used by the ETS application in 
REM "Developing Oracle Forms Applications"
REM
PROMPT
PROMPT Create the tables used by the ETS application.
PROMPT 

CREATE TABLE hardware (
hw_serial_num CHAR(6) CONSTRAINT hw_pk PRIMARY KEY,
name VARCHAR2(30) CONSTRAINT hw_name_nn NOT NULL,
manufacturer VARCHAR2(30),
model VARCHAR2(20),
purchase_cost NUMBER(8,2),
purchase_dt DATE,
cs_phone VARCHAR2(10),
cs_cost NUMBER(8,2) 
);
INSERT INTO HARDWARE VALUES ('95-N45','PERSONAL COMPUTER','DELL','DIMENSION P90','2454.99','12-OCT-95','8001231232',''); 
INSERT INTO HARDWARE VALUES ('96-N45','PERSONAL COMPUTER','DELL','DIMENSION P90','2000','22-JAN-96','8001231232',''); 
INSERT INTO HARDWARE VALUES ('96-N46','PERSONAL COMPUTER','DELL','DIMENSION P90','2000','02-FEB-96','8001231232',''); 
INSERT INTO HARDWARE VALUES ('96-N47','PERSONAL COMPUTER','DELL','DIMENSION P90','2000','02-JAN-96','8001231232',''); 
INSERT INTO HARDWARE VALUES ('M12021','MONITOR','PACKARD BELL','1232-A1','231','01-SEP-95','8001229929','123'); 
INSERT INTO HARDWARE VALUES ('M12022','MONITOR','PACKARD BELL','1232-A1','231','01-SEP-95','8001229929','123'); 
INSERT INTO HARDWARE VALUES ('M12023','MONITOR','PACKARD BELL','1232-A2','280','01-SEP-95','8001229929','123'); 
INSERT INTO HARDWARE VALUES ('M12024','MONITOR','PACKARD BELL','1232-A3','380','01-SEP-95','8001229929','123'); 
INSERT INTO HARDWARE VALUES ('CQ1000','PERSONAL COMPUTER','COMPAQ','AS323','1200','21-OCT-95','8001233212',''); 
INSERT INTO HARDWARE VALUES ('CQ1001','PERSONAL COMPUTER','COMPAQ','AS323','1200','21-OCT-95','8001233212',''); 
INSERT INTO HARDWARE VALUES ('CQ1002','PERSONAL COMPUTER','COMPAQ','AS323','1200','21-OCT-95','8001233212',''); 
INSERT INTO HARDWARE VALUES ('CQ1003','PERSONAL COMPUTER','COMPAQ','AS323','1200','21-OCT-95','8001233212',''); 
INSERT INTO HARDWARE VALUES ('DL1000','PERSONAL COMPUTER','DELL CORPORATION','DIMENSION P90','1800','11-NOV-95','8007563398',''); 
INSERT INTO HARDWARE VALUES ('95-N69','MONITOR','PACKARD BELL','SEQ-1232','750','21-AUG-95','8009889898',''); 
INSERT INTO HARDWARE VALUES ('95-N46','PERSONAL COMPUTER','DELL CORPOTATION','XTP-1930','1500','31-MAY-95','8009098989','123'); 
INSERT INTO HARDWARE VALUES ('95-N55','PERSONAL COMPUTER','DELL','DIMENSION P90','2454.99','12-OCT-95','8001231232',''); 
COMMIT;

CREATE TABLE software (
sw_serial_num CHAR(6) CONSTRAINT sw_pk PRIMARY KEY,
hw_serial_num CHAR(6) CONSTRAINT sw_fk 
REFERENCES hardware(hw_serial_num),
name VARCHAR2(30) CONSTRAINT sw_name_nn NOT NULL,
version VARCHAR2(10),
purchase_cost NUMBER(8,2),
purchase_dt DATE 
);
INSERT INTO SOFTWARE VALUES ('N45-01','95-N45','MS DOS','6.2','','12-OCT-95'); 
INSERT INTO SOFTWARE VALUES ('N45-02','95-N45','MS WINDOWS','3.1','','12-OCT-95'); 
INSERT INTO SOFTWARE VALUES ('N45-03','95-N45','PERSONAL ORACLE7','7.1','','23-NOV-95'); 
INSERT INTO SOFTWARE VALUES ('CQ2-01','CQ1002','MS DOS','6.2','','21-OCT-95'); 
INSERT INTO SOFTWARE VALUES ('CQ2-02','CQ1002','MS WINDOWS','3.1','','21-OCT-95'); 
INSERT INTO SOFTWARE VALUES ('CQ2-03','CQ1002','PERSONAL ORACLE7','7.1','','21-OCT-95'); 
COMMIT;

Base de MDR

CREATE TABLE movie (
movie_id NUMBER CONSTRAINT movie_pk PRIMARY KEY,
title VARCHAR2(30) CONSTRAINT movie_nn NOT NULL,
director VARCHAR2(30),
actor VARCHAR2(30),
actress VARCHAR2(30),
rating VARCHAR2(8)
);
INSERT INTO MOVIE VALUES ('231','JFK','Oliver Stone','Kevin Kostner','Sissy Spacek','3'); 
INSERT INTO MOVIE VALUES ('238','The Godfather','Francis Ford Copola','Marlon Brando','Dean Keaton','3'); 
INSERT INTO MOVIE VALUES ('243','Gone with the Wind','Victor Fleming','Clark Gable','Vivien Leigh','2'); 
INSERT INTO MOVIE VALUES ('247','Doctor Zhivago','David Lean','Omar Sharif','Julie Christie','2'); 
INSERT INTO MOVIE VALUES ('100','The Silence of Lambs','Jonathan Demme','Anthony Hopkins','Jodie Foster','2'); 
INSERT INTO MOVIE VALUES ('261','The Piano','Jane Champion','Harvey Keitel','Holly Hunter','3'); 
INSERT INTO MOVIE VALUES ('265','Cinema Paradiso','Giuseppe Tornatore','Philippe Noiret','Antonella Attili','3'); 
INSERT INTO MOVIE VALUES ('208','Amadeus','Milos Forman','E. Murray Abrahams','Elisabeth Berridge','2'); 
INSERT INTO MOVIE VALUES ('321','Ghandi','Richard Attenborough','Ben Kingslay','Candice Bergen','2'); 
INSERT INTO MOVIE VALUES ('10','Pulp Fiction','','','','R'); 
INSERT INTO MOVIE VALUES ('20','Jefferson in Paris','','','',''); 
INSERT INTO MOVIE VALUES ('30','Howards End','','Anthony Hopkins','Emma Thompson',''); 
INSERT INTO MOVIE VALUES ('203','The Remains of the Day','','Anthony Hopkins','Emma Thompson','G'); 
INSERT INTO MOVIE VALUES ('50','A Walk in the Clouds','','','',''); 
INSERT INTO MOVIE VALUES ('60','Something to Talk About','','','',''); 
INSERT INTO MOVIE VALUES ('70','Scent of a Woman','','','',''); 
INSERT INTO MOVIE VALUES ('80','When a Man Loves a Woman','','','',''); 
INSERT INTO MOVIE VALUES ('110','Much Ado About Nothing','','Denzel Washington','Emma Thompson','');
COMMIT;

CREATE TABLE customer (
customer_id NUMBER CONSTRAINT cust_pk PRIMARY KEY,
last_name VARCHAR2(30) CONSTRAINT cust_lnm_nn NOT NULL,
first_name VARCHAR2(30),
phone VARCHAR2(14),
dob DATE,
member_dt DATE
);
INSERT INTO CUSTOMER VALUES ('10','Moore','John','(202) 234-3223','12-MAR-65','27-MAR-94'); 
INSERT INTO CUSTOMER VALUES ('20','Campbell','Karen','(202) 111-2222','09-APR-80','14-NOV-94'); 
INSERT INTO CUSTOMER VALUES ('30','Smith','Robert','(202) 222-1111','31-MAY-66','01-SEP-95'); 
INSERT INTO CUSTOMER VALUES ('40','Richard','Joanne','(202) 212-1212','17-FEB-60','25-JUL-95'); 
INSERT INTO CUSTOMER VALUES ('50','Moore','Suzanne','','','24-MAR-95'); 
INSERT INTO CUSTOMER VALUES ('60','Moore','Karla','','','30-JUL-95'); 
INSERT INTO CUSTOMER VALUES ('70','Campbell','Michael','','','19-AUG-95'); 
INSERT INTO CUSTOMER VALUES ('230','Andrews','Rebecca','7053567712','12-MAR-69','19-FEB-95'); 
INSERT INTO CUSTOMER VALUES ('326','Milton','Henry','7037213725','21-SEP-53','12-MAY-95'); 
INSERT INTO CUSTOMER VALUES ('327','Jackson','Cindy','7038547854','31-OCT-43','30-AUG-94'); 
INSERT INTO CUSTOMER VALUES ('329','Jeffrey','Denning','7055435712','15-MAR-64','19-FEB-96'); 
INSERT INTO CUSTOMER VALUES ('330','Mayer','Arthur','7037213324','11-JUN-73','12-MAY-96'); 
INSERT INTO CUSTOMER VALUES ('331','Baker','Paul','7038542154','19-DEC-69','30-SEP-95'); 
INSERT INTO CUSTOMER VALUES ('332','Johnson','Michelle','7038659856','21-MAR-66','20-APR-95'); 
COMMIT;

CREATE TABLE rental (
customer_id NUMBER,
movie_id NUMBER,
rent_dt DATE,
return_dt DATE,
daily_rate NUMBER(4, 2),
constraint rental_pk primary key (customer_id, movie_id, rent_dt),
constraint rental_cust_id_fk foreign key (customer_id)
references customer
on delete cascade,
constraint rental_movie_id_fk foreign key (movie_id)
references movie
on delete cascade
);
INSERT INTO RENTAL VALUES ('327','247','10-MAR-96','11-MAR-96','1.99'); 
INSERT INTO RENTAL VALUES ('332','265','01-MAR-96','13-MAR-96','.99'); 
INSERT INTO RENTAL VALUES ('331','265','29-FEB-96','02-MAR-96','1.99'); 
INSERT INTO RENTAL VALUES ('331','238','11-MAR-96','13-MAR-96','1.99'); 
INSERT INTO RENTAL VALUES ('230','247','11-MAR-96','13-MAR-96','1.29'); 
INSERT INTO RENTAL VALUES ('331','261','11-MAR-96','13-MAR-96','.99'); 
INSERT INTO RENTAL VALUES ('230','231','11-MAR-96','13-MAR-96','1.49'); 
INSERT INTO RENTAL VALUES ('332','261','11-MAR-96','13-MAR-96','1.99'); 
INSERT INTO RENTAL VALUES ('332','231','11-MAR-96','13-MAR-96','1.99'); 
INSERT INTO RENTAL VALUES ('327','243','11-MAR-96','13-MAR-96','.99'); 
INSERT INTO RENTAL VALUES ('70','203','02-SEP-95','03-SEP-95','.99'); 
INSERT INTO RENTAL VALUES ('70','208','02-SEP-95','04-SEP-95','1.99'); 
INSERT INTO RENTAL VALUES ('60','208','03-SEP-95','04-SEP-95','1.99'); 
INSERT INTO RENTAL VALUES ('40','203','03-SEP-95','04-SEP-95','.99'); 
INSERT INTO RENTAL VALUES ('30','203','12-JUN-95','13-JUN-95','.99'); 
INSERT INTO RENTAL VALUES ('60','203','21-NOV-95','23-NOV-95','.99'); 
INSERT INTO RENTAL VALUES ('20','203','21-AUG-95','22-AUG-95','.99'); 
INSERT INTO RENTAL VALUES ('20','208','21-AUG-95','22-AUG-95','1.99'); 
INSERT INTO RENTAL VALUES ('30','208','22-AUG-95','23-AUG-95','1.99'); 
INSERT INTO RENTAL VALUES ('10','203','22-AUG-95','23-AUG-95','.99'); 
INSERT INTO RENTAL VALUES ('40','208','24-AUG-95','25-AUG-95','1.99'); 
INSERT INTO RENTAL VALUES ('50','208','24-AUG-95','26-AUG-95','1.99'); 
INSERT INTO RENTAL VALUES ('50','203','24-AUG-95','26-AUG-95','.99'); 
INSERT INTO RENTAL VALUES ('10','208','23-AUG-95','24-AUG-95','1.99'); 
INSERT INTO RENTAL VALUES ('30','203','23-AUG-95','24-AUG-95','.99'); 
INSERT INTO RENTAL VALUES ('60','203','23-AUG-95','24-AUG-95','.99'); 
INSERT INTO RENTAL VALUES ('20','10','12-NOV-95','','.99'); 
COMMIT;

CREATE TABLE late_return (
customer_id NUMBER,
last_name VARCHAR2(30),
first_name VARCHAR2(30),
phone VARCHAR2(14),
title VARCHAR2(30),
rent_dt DATE,
return_dt DATE
);

CREATE TABLE customers (
customer_id NUMBER CONSTRAINT custs_pk PRIMARY KEY,
last_name VARCHAR2(30) CONSTRAINT custs_lnm_nn NOT NULL,
first_name VARCHAR2(30) CONSTRAINT custs_fnm_nn NOT NULL,
gender CHAR(1),
dob DATE,
member_dt DATE,
status CHAR(1),
address VARCHAR2(50),
city VARCHAR2(30),
state CHAR(2),
zip VARCHAR2(10),
day_phone VARCHAR2(10),
eve_phone VARCHAR2(10),
comedy CHAR(1),
drama CHAR(1),
mystery CHAR(1),
foreign CHAR(1)
);
INSERT INTO CUSTOMERS VALUES ('230','Andrews','Rebecca','F','12-MAR-69','19-FEB-95','A',
'1456 Sycamore St','Falls Church','VA','22040','7038661521','7053567712','Y','','',''); 
INSERT INTO CUSTOMERS VALUES ('326','Milton','Henry','M','21-SEP-53','12-MAY-95','A',
'1723 Marshall Lane','Arlington','VA','22019','3019522214','7037213725','Y','Y','',''); 
INSERT INTO CUSTOMERS VALUES ('327','Jackson','Cindy','F','31-OCT-43','30-AUG-94','A',
'123 Courthouse Road','Fairfax','VA','22102','7034454454','7038547854','Y','','','Y'); 
INSERT INTO CUSTOMERS VALUES ('329','Jeffrey','Denning','M','15-MAR-64','19-FEB-96','A',
'1721 Whitney Drive','Falls Church','VA','22040','7036547896','7055435712','Y','','',''); 
INSERT INTO CUSTOMERS VALUES ('330','Mayer','Arthur','M','11-JUN-73','12-MAY-96','A',
'729 Castle Ct','Reston','VA','22019','7038246545','7037213324','','','Y','Y'); 
INSERT INTO CUSTOMERS VALUES ('331','Baker','Paul','M','19-DEC-69','30-SEP-95','A',
'1423 North 15th Rd','Arlington','MD','22102','7034257894','7038542154','','Y','',''); 
INSERT INTO CUSTOMERS VALUES ('332','Johnson','Michelle','F','21-MAR-66','20-APR-95','A',
'123 North Main Street Apt. 309','Falls Church','MD','20129','7035643215','7038659856','','','Y',''); 
COMMIT;

CREATE TABLE movies (
movie_id NUMBER CONSTRAINT movies_pk PRIMARY KEY,
title VARCHAR2(30) CONSTRAINT movies_nn NOT NULL,
status CHAR(1),
director VARCHAR2(30),
actor VARCHAR2(30),
actress VARCHAR2(30),
producer VARCHAR2(30),
company VARCHAR2(30),
start_dt DATE,
end_dt DATE,
rating CHAR(1)
);

INSERT INTO MOVIES VALUES ('231','JFK','A','Oliver Stone','Kevin Kostner','Sissy Spacek',
'Kitman Ho / Oliver Stone','Warner Bros.','01-JAN-91','','3'); 
INSERT INTO MOVIES VALUES ('238','The Godfather','A','Francis Ford Copola','Marlon Brando',
'Dean Keaton','Albert S. Ruddy','Pramount Pictures','01-JAN-72','','3'); 
INSERT INTO MOVIES VALUES ('243','Gone with the Wind','A','Victor Fleming','Clark Gable',
'Vivien Leigh','David Selznik','MGM','','','2'); 
INSERT INTO MOVIES VALUES ('247','Doctor Zhivago','A','David Lean','Omar Sharif',
'Julie Christie','Carlo Ponti','MGM','','','2'); 
INSERT INTO MOVIES VALUES ('250','The Silence of Lambs','A','Jonathan Demme','Anthony Hopkins',
'Jodie Foster','Keneth Uff / Edward Saxon','Orion Pictures Corporation','01-JAN-90','','2'); 
INSERT INTO MOVIES VALUES ('261','The Piano','A','Jane Champion','Harvey Keitel',
'Holly Hunter','Jan Chapman','MIRAMAX','01-JAN-92','','3'); 
INSERT INTO MOVIES VALUES ('265','Cinema Paradiso','A','Giuseppe Tornatore','Philippe Noiret',
'Antonella Attili','Franco Cristaldi','MIRAMAX','01-JAN-91','','3'); 
INSERT INTO MOVIES VALUES ('271','Amadeus','A','Milos Forman','E. Murray Abrahams',
'Elisabeth Berridge','Saul Zaentz','Saul Zaentz Group','01-JAN-84','','2'); 
INSERT INTO MOVIES VALUES ('321','Ghandi','A','Richard Attenborough','Ben Kingslay',
'Candice Bergen','Terence A. Clegg','Columbia Pictures','01-JAN-82','','2'); 
COMMIT;

CREATE TABLE tapes (
tape_id NUMBER CONSTRAINT tapes_pk PRIMARY KEY,
movie_id NUMBER,
status CHAR(1),
CONSTRAINT tapes_movie_id_fk FOREIGN KEY (movie_id)
REFERENCES movies
ON DELETE CASCADE
);
INSERT INTO TAPES VALUES ('235','231','A'); 
INSERT INTO TAPES VALUES ('236','231','A'); 
INSERT INTO TAPES VALUES ('239','238','A'); 
INSERT INTO TAPES VALUES ('234','231','A'); 
INSERT INTO TAPES VALUES ('240','238','A'); 
INSERT INTO TAPES VALUES ('241','238','A'); 
INSERT INTO TAPES VALUES ('244','243','A'); 
INSERT INTO TAPES VALUES ('245','243','A'); 
INSERT INTO TAPES VALUES ('248','247','A'); 
INSERT INTO TAPES VALUES ('249','247','A'); 
INSERT INTO TAPES VALUES ('251','250','A'); 
INSERT INTO TAPES VALUES ('252','250','A'); 
INSERT INTO TAPES VALUES ('253','250','A'); 
INSERT INTO TAPES VALUES ('262','261','A'); 
INSERT INTO TAPES VALUES ('263','261','A'); 
INSERT INTO TAPES VALUES ('266','265','A'); 
INSERT INTO TAPES VALUES ('267','265','A'); 
INSERT INTO TAPES VALUES ('272','271','A'); 
INSERT INTO TAPES VALUES ('273','271','A'); 
INSERT INTO TAPES VALUES ('274','271','A'); 
INSERT INTO TAPES VALUES ('276','271','A'); 
INSERT INTO TAPES VALUES ('322','321','A'); 
INSERT INTO TAPES VALUES ('323','321','A'); 
INSERT INTO TAPES VALUES ('324','321','A'); 
COMMIT;

CREATE TABLE rentals (
customer_id NUMBER,
tape_id NUMBER,
rent_dt DATE,
return_dt DATE,
daily_rate NUMBER(4, 2),
CONSTRAINT rentals_pk PRIMARY KEY (customer_id, tape_id, rent_dt),
CONSTRAINT rentals_cust_id_fk FOREIGN KEY (customer_id)
REFERENCES customers
ON DELETE CASCADE,
CONSTRAINT rentals_tape_id_fk FOREIGN KEY (tape_id)
REFERENCES tapes
ON DELETE CASCADE
);
INSERT INTO RENTALS VALUES ('327','248','10-MAR-96','11-MAR-96','1.99'); 
INSERT INTO RENTALS VALUES ('329','253','21-MAR-96','23-MAR-96','1.99'); 
INSERT INTO RENTALS VALUES ('332','266','01-MAR-96','13-MAR-96','.99'); 
INSERT INTO RENTALS VALUES ('331','266','29-FEB-96','02-MAR-96','1.99'); 
INSERT INTO RENTALS VALUES ('331','239','11-MAR-96','13-MAR-96','1.99'); 
INSERT INTO RENTALS VALUES ('230','248','11-MAR-96','13-MAR-96','1.29'); 
INSERT INTO RENTALS VALUES ('331','262','11-MAR-96','13-MAR-96','.99'); 
INSERT INTO RENTALS VALUES ('230','235','11-MAR-96','13-MAR-96','1.49'); 
INSERT INTO RENTALS VALUES ('332','263','11-MAR-96','13-MAR-96','1.99'); 
INSERT INTO RENTALS VALUES ('332','235','11-MAR-96','13-MAR-96','1.99'); 
INSERT INTO RENTALS VALUES ('327','245','11-MAR-96','13-MAR-96','.99'); 
INSERT INTO RENTALS VALUES ('327','276','11-MAR-96','13-MAR-96','.99'); 
COMMIT;

CREATE TABLE states (
code CHAR(2) CONSTRAINT state_pk PRIMARY KEY,
name VARCHAR(50)
);
INSERT INTO STATES VALUES ('VA','Virginia'); 
INSERT INTO STATES VALUES ('MD','Maryland'); 
INSERT INTO STATES VALUES ('NY','New York'); 
INSERT INTO STATES VALUES ('DC','District of Columbia'); 
INSERT INTO STATES VALUES ('TX','Texas'); 
INSERT INTO STATES VALUES ('IL','Illinois'); 
INSERT INTO STATES VALUES ('AZ','Arizona'); 
INSERT INTO STATES VALUES ('ND','North Dakota'); 
INSERT INTO STATES VALUES ('SD','South Dakota'); 
INSERT INTO STATES VALUES ('NM','New Mexico'); 
INSERT INTO STATES VALUES ('NJ','New Jersey'); 
INSERT INTO STATES VALUES ('NH','New Hampshire'); 
INSERT INTO STATES VALUES ('OH','Ohio'); 
INSERT INTO STATES VALUES ('GA','Georgia'); 
INSERT INTO STATES VALUES ('SC','South Carolina'); 
INSERT INTO STATES VALUES ('NC','North Carolina'); 
INSERT INTO STATES VALUES ('FL','Florida'); 
INSERT INTO STATES VALUES ('VT','Vermont'); 
INSERT INTO STATES VALUES ('MA','Massachussets'); 
INSERT INTO STATES VALUES ('OK','Oklahoma'); 
INSERT INTO STATES VALUES ('WA','Washington'); 
INSERT INTO STATES VALUES ('KY','Kentuky'); 
INSERT INTO STATES VALUES ('WV','West Virgina'); 
INSERT INTO STATES VALUES ('PA','Pennsylvania'); 
INSERT INTO STATES VALUES ('TN','Tennessee'); 
INSERT INTO STATES VALUES ('LO','Louisiana'); 
INSERT INTO STATES VALUES ('ID','Idaho'); 
INSERT INTO STATES VALUES ('CA','California'); 
INSERT INTO STATES VALUES ('UT','Utah'); 
COMMIT;