rem  ==========================================================================
rem  Project:	INFSCI 2710 "Database Management"
rem  Version:	Spring 2000
rem  Module:	cd.sql
rem  Purpose:	CREATE TABLE Statements for Composer/CD Example Database
rem  Created:	1991
rem  Last Change: 03.02.2000
rem  Language:	Oracle SQL*Plus
rem  Authors:	Stefan Brass
rem  Email:	sbrass@sis.pitt.edu
rem  Address:	Univ. of Pittsburgh, School of Information Sc., PA 15260, USA
rem  Copyright:	(c) 1991-2000 by Stefan Brass
rem  Copying:	You may do anything with this, but don't make me responsible.
rem  ==========================================================================

rem  --------------------------------------------------------------------------
rem  You may use this program code, but you cannot make me or the University of
rem  Pittsburgh or anybody else liable in any way for any bugs or damage.
rem  This program code comes without any guarantee. I have written it in a big
rem  hurry, so it is very probable that it contains errors.
rem  I am continually trying to improve the code.
rem  If you find errors or have improvements, please tell me.
rem  Formally, the GNU Public Licence applies to this code.
rem  (You may also simply use it and pretend that you have written it.)
rem  The data may be wrong. It may be possible that the CD vendors have a
rem  copyright on it. The CDs are old (about 10 years), so it might be more
rem  of historical interest that an actual basis for choosing CDs.
rem  Use the data at your own risk.
rem  --------------------------------------------------------------------------

SET ECHO OFF

rem ##################################################################

PROMPT "The old versions of the tables are deleted."
PROMPT "Do not worry about the message  Table does not exist ..."

DROP TABLE SOLOIST;
DROP TABLE RECORDING;
DROP TABLE PIECE;
DROP TABLE CD;
DROP TABLE COMPOSER;

rem ##################################################################

PROMPT "The tables are being created..."

PROMPT "COMPOSER: "

CREATE TABLE COMPOSER(
	CNO NUMBER(2)
		CONSTRAINT COMOSER_KEY PRIMARY KEY
		CONSTRAINT CNO_VALID CHECK(CNO >= 0),
	LAST VARCHAR(25) NOT NULL,
	FIRST VARCHAR(20),
	BORN NUMBER(4)
		CONSTRAINT BORN_VALID_YEAR CHECK(BORN >= 500 AND BORN < 3000),
	DIED NUMBER(4)
		CONSTRAINT DIED_VALID_YEAR CHECK(DIED >= 500 AND DIED < 3000)
);

PROMPT "   ... inserting data ..."

insert into COMPOSER values(11,'H"andel','Georg Friedrich',1685,1759);
insert into COMPOSER values(12,'Prokofiev','Serge',1891,1953);
insert into COMPOSER values(13,'Monteverdi','Claudio',1567,1643);
insert into COMPOSER values(14,'Dvorak','Antonin',1841,1904);
insert into COMPOSER values(15,'Vivaldi','Antonio',1678,1741);
insert into COMPOSER values(16,'Mozart','Leopold',1719,1787);
insert into COMPOSER values(17,'Biber','Heinrich Ignaz Franz',1644,1704);
insert into COMPOSER values(18,'Telemann','Georg Philipp',1681,1767);
insert into COMPOSER values(19,'Byrd','William',1543,1623);
insert into COMPOSER values(20,'Mozart','Wolfgang Amadeus',1756,1791);
insert into COMPOSER values(21,'Beethoven','Ludwig van',1770,1827);
insert into COMPOSER values(22,'Bach','Johann Sebastian',1685,1750);
insert into COMPOSER values(23,'Mahler','Gustav',1860,1911);
insert into COMPOSER values(24,'Sibelius','Jean',1865,1957);
insert into COMPOSER values(25,'Berlioz','Hector',1803,1869);
insert into COMPOSER values(26,'Hayden','Joseph',1732,1809);
insert into COMPOSER values(27,'Tschaikowsky','Peter',1840,1893);
insert into COMPOSER values(28,'Mendelssohn Bartholdy','Felix',1809,1847);
insert into COMPOSER values(29,'Schubert','Franz',1797,1828);
insert into COMPOSER values(30,'Orff','Carl',1895,null);
insert into COMPOSER values(31,'Schostakowitsch','Dmitri',1906,1975);
insert into COMPOSER values(32,'Desprez','Josquin',1440,1521);
insert into COMPOSER values(33,'Wolf-Ferrari','Ermanno',1876,1948);
insert into COMPOSER values(34,'Brahms','Johannes',1833,1897);
insert into COMPOSER values(35,'Marcello','Benedetto',1686,1739);
insert into COMPOSER values(36,'Leclair','Lean-Marie',1697,1764);
insert into COMPOSER values(37,'Corelli','Arcangelo',1653,1713);
insert into COMPOSER values(38,'Albinoni','Tommaso',1671,1750);
insert into COMPOSER values(39,'Scarlatti','Domenico',1685,1757);
insert into COMPOSER values(40,'Manfredini','Francesco',1680,1748);
insert into COMPOSER values(41,'Locatelli','Pietro',1695,1764);
insert into COMPOSER values(42,'Franck','Melchior',1580,1639);
insert into COMPOSER values(43,'Heselloher','Hans',1420,1485);
insert into COMPOSER values(44,'Mainerio','Giorgio',1545,1582);
insert into COMPOSER values(45,'Fogliano','Giacomo',1468,1548);
insert into COMPOSER values(46,'Isaak','Heinrich',1450,1517);
insert into COMPOSER values(47,'Da Nola','Giovan Domenico',1510,1592);
insert into COMPOSER values(48,'Azzaiolo','Filippo',1530,1569);
insert into COMPOSER values(49,'Susato','Tilman',1500,1561);
insert into COMPOSER values(50,'Janequin','Clement',1485,1558);

remark ************************************************************************

PROMPT "PIECE: "

CREATE TABLE PIECE(
	PNO NUMBER(4)
		CONSTRAINT PIECE_KEY PRIMARY KEY
		CONSTRAINT PNO_VALID CHECK(PNO >= 0),
	CNO NUMBER(2)
		CONSTRAINT PIECE_REF_COMPOSER REFERENCES COMPOSER,
	TITLE VARCHAR(45) NOT NULL,
	TUNE VARCHAR(7),
	OPUS VARCHAR(15)
);

PROMPT "   ... inserting data ..."

insert into PIECE values
(1001,11,'Concerto grosso op.6 Nr.7','B-dur','Op.6 Nr.7');
insert into PIECE values
(1002,11,'Fireworks Music (Concerto grosso)','D-dur',null);
insert into PIECE values
(1003,11,'Concerto grosso op.6 Nr.8','c-moll','Op.6 Nr.8');
insert into PIECE values
(1004,11,'Sinfonia e-moll (aus `Der Messias'')','e-moll',null);
insert into PIECE values
(1005,12,'Concert for Violin and Orchestra No.1','D-dur','Op.19');
insert into PIECE values
(1006,12,'Concert for Violin and Orchestra No.2','g-moll','Op.63');
insert into PIECE values
(1007,13,'Verspro Della Beata Vergine',null,null);
insert into PIECE values
(1008,14,'Slawic Dances op.46',null,'Op.46 Nr.1-8');
insert into PIECE values
(1009,14,'Slawic Dances op.72',null,'Op.72 Nr.1-8');
insert into PIECE values
(1010,15,'The Spring','E-dur','Op.8 Nr.1 RV269');
insert into PIECE values
(1011,15,'The Summer','g-moll','Op.8 Nr.2 RV315');
insert into PIECE values
(1012,15,'The Autumn','F-dur','Op.8 Nr.3 RV293');
insert into PIECE values
(1013,15,'The Winter','f-moll','Op.8 Nr.4 RV297');
insert into PIECE values
(1014,16,'Sinfonia D-Dur mit Dudelsack und Drehleier','D-dur',null);
insert into PIECE values
(1015,17,'Serenada C-Dur mit dem Nachw"achterlied','C-Dur',null);
insert into PIECE values
(1016,null,'Kleine St"ucke f"ur Dudelsack und Drehleier',null,null);
insert into PIECE values
(1017,15,'Concerto per archi e cembalo','G-Dur',null);
insert into PIECE values
(1018,15,'Sinfonia C-Dur','C-Dur',null);
insert into PIECE values
(1019,15,'Concerto per violino e archi','a-moll','Op.3 Nr.6');
insert into PIECE values
(1020,17,'Sonata III a 5 Violae',null,null);
insert into PIECE values
(1021,17,'Sonata prima a 8, 2 Clarini, 6 Violae',null,null);
insert into PIECE values
(1022,17,'Ballettae a 4 Violettae',null,null);
insert into PIECE values
(1023,17,'Battalia',null,null);
insert into PIECE values
(1024,17,'Sonata a 7, 6 Tromb, Tamburin con Organo',null,null);
insert into PIECE values
(1025,17,'Sonata IV a 5 Violae',null,null);
insert into PIECE values
(1026,17,'Sonata seconda a 8, 2 Clarini, 6 Violae',null,null);
insert into PIECE values
(1027,17,'Sonata a 6 (die Pauern Kirchfahrt genandt)',null,null);
insert into PIECE values
(1028,18,'Overture in D (2 Trompeten, Pauken, ...)','D-Dur',null);
insert into PIECE values
(1029,18,'Concerto in D (3 Trompeten, Pauken, Oboen,..)','D-Dur',null);
insert into PIECE values
(1030,18,'Sinfonia in F (Trompete, 3 Posaunen, ...)','F-Dur',null);
insert into PIECE values
(1031,18,'Concerto in D (Trompete, 2 Oboen, continuo)','D-Dur',null);
insert into PIECE values
(1032,18,'Concerto in D (Trompete, 2 Oboen, ...)','D-Dur',null);
insert into PIECE values
(1033,18,'Concerto in D (Trompete, Streicher, continuo)','D-Dur',null);
insert into PIECE values
(1034,18,'Concerto in D (Trompete, Streicher, continuo)','D-Dur',null);
insert into PIECE values
(1035,18,'Suite in D (Trompete, Streicher, continuo)','D-Dur',null);
insert into PIECE values
(1036,18,'Concerto in Es (2 Trompeten, Streicher, cont)','Es-Dur',null);
insert into PIECE values
(1037,19,'Mass for five voices',null,null);
insert into PIECE values
(1038,19,'Mass for four voices',null,null);
insert into PIECE values
(1039,19,'Mass for three voices',null,null);
insert into PIECE values
(1040,19,'Ave verum corpus',null,null);
insert into PIECE values
(1041,21,'Die Gesch"opfe des Prometheus, Ouvert"ure',null,'Op.43');
insert into PIECE values
(1042,20,'Die Entf"uhrung aus dem Serail, Ouvert"ure',null,'KV 384');
insert into PIECE values
(1043,21,'Fidelio, Ouvert"ure',null,'Op.94');
insert into PIECE values
(1044,20,'Die Zauberfl"ote, Ouvert"ure',null,'KV 620');
insert into PIECE values
(1045,21,'Egmont, Ouvert"ure',null,'Op.84');
insert into PIECE values
(1046,20,'Die Hochzeit des Figaro, Ouvert"ure',null,'KV 492');
insert into PIECE values
(1047,21,'Leonore III, Ouvert"ure',null,'Op.72b');
insert into PIECE values
(1048,20,'Titus, Ouvert"ure',null,'KV 621');
insert into PIECE values
(1049,21,'Coriolan, Ouvert"ure',null,'Op.62');
insert into PIECE values
(1050,13,'Cantate Domine - Motet',null,null);
insert into PIECE values
(1051,13,'Mass for four voices (1650)',null,null);
insert into PIECE values
(1052,13,'Domine, ne in furore - Motet',null,null);
insert into PIECE values
(1053,13,'Mass `In illo tempore'' for six voices (1610)',null,null);
insert into PIECE values
(1054,22,'Violin Concerto a-minor','a-moll','BWV 1041');
insert into PIECE values
(1055,22,'Violin Concerto E-major','E-dur','BWV 1042');
insert into PIECE values
(1056,22,'Concerto d-minor for 2 Violins','d-moll','BWV 1043');
insert into PIECE values
(1057,22,'Konzert d-minor for Oboe and Violin','d-moll','BWV 1060');
insert into PIECE values
(1058,12,'Symphonie Nr.1 D-dur `Symphonie classique''','D-dur','Op.25');
insert into PIECE values
(1059,12,'Symphonie Nr.5 B-dur','B-dur','Op.100');
insert into PIECE values
(1060,23,'Sinfonie Nr.4 G-dur','G-dur',null);
insert into PIECE values
(1061,24,'Symphonie Nr.2 D-dur','D-dur','Op.43');
insert into PIECE values
(1062,24,'`Finlandia''',null,'Op.26');
insert into PIECE values
(1063,24,'`Valse triste''',null,'Op.44');
insert into PIECE values
(1064,24,'`The Swan of Tuonela''',null,'Op.22 Nr.2');
insert into PIECE values
(1065,11,'Wassermusik, Suite in F-dur','F-dur',null);
insert into PIECE values
(1066,11,'Wassermusik, Suite in D/G-dur',null,null);
insert into PIECE values
(1067,11,'Concerto a due cori no.2',null,null);
insert into PIECE values
(1068,11,'Concerto a due cori no.3',null,null);
insert into PIECE values
(1069,11,'Concerto grosso op.3 Nr.1','B-dur','Op.3 Nr.1');
insert into PIECE values
(1070,11,'Concerto grosso op.3 Nr.2','B-dur','Op.3 Nr.2');
insert into PIECE values
(1071,11,'Concerto grosso op.3 Nr.3','G-dur','Op.3 Nr.3');
insert into PIECE values
(1072,11,'Concerto grosso op.3 Nr.4','F-dur','Op.3 Nr.4');
insert into PIECE values
(1073,11,'Concerto grosso op.3 Nr.5','d-moll','Op.3 Nr.5');
insert into PIECE values
(1074,11,'Concerto grosso op.3 Nr.6','D-dur','Op.3 Nr.6');
insert into PIECE values
(1075,11,'Concerto grosso op.6 Nr.1','G-dur','Op.6 Nr.1');
insert into PIECE values
(1076,11,'Concerto grosso op.6 Nr.2','F-dur','Op.6 Nr.2');
insert into PIECE values
(1077,11,'Concerto grosso op.6 Nr.3','e-moll','Op.6 Nr.3');
insert into PIECE values
(1078,11,'Concerto grosso op.6 Nr.4','a-moll','Op.6 Nr.4');
insert into PIECE values
(1079,11,'Concerto grosso op.6 Nr.5','D-dur','Op.6 Nr.5');
insert into PIECE values
(1080,11,'Concerto grosso op.6 Nr.6','g-moll','Op.6 Nr.6');
insert into PIECE values
(1081,11,'Concerto grosso op.6 Nr.9','F-dur','Op.6 Nr.9');
insert into PIECE values
(1082,11,'Concerto grosso op.6 Nr.10','d-moll','Op.6 Nr.10');
insert into PIECE values
(1083,11,'Concerto grosso op.6 Nr.11','A-dur','Op.6 Nr.11');
insert into PIECE values
(1084,11,'Concerto grosso op.6 Nr.12','b-moll','Op.6 Nr.12');
insert into PIECE values
(1085,25,'Symphonie Fantastique',null,'Op.14a');
insert into PIECE values
(1086,25,'Harold in Italy',null,'Op.16');
insert into PIECE values
(1087,25,'Overture - Rob Roy',null,null);
insert into PIECE values
(1088,25,'Overture - The Corsair',null,'Op.21');
insert into PIECE values
(1089,12,'Cinderella (Suite)',null,null);
insert into PIECE values
(1090,16,'Hornkonzert D-dur','D-dur','KV 386b 412/514');
insert into PIECE values
(1091,16,'Hornkonzert Es-dur','Es-dur','KV 495');
insert into PIECE values
(1092,16,'Rondo in Es-dur','Es-dur','KV 371');
insert into PIECE values
(1093,16,'Hornkonzert Es-dur','Es-dur','KV 447');
insert into PIECE values
(1094,16,'Hornkonzert Es-dur','Es-dur','KV 417');
insert into PIECE values
(1095,26,'Cellokonzert C-dur','C-dur','Hob. VIIb: 1');
insert into PIECE values
(1096,26,'Cellokonzert D-dur','D-dur','Hob. VIIb: 2');
insert into PIECE values
(1097,18,'Violinkonzert Nr.4','E-dur',null);
insert into PIECE values
(1098,18,'Violinkonzert Nr.11','B-dur',null);
insert into PIECE values
(1099,18,'Violinkonzert Nr.8','G-dur',null);
insert into PIECE values
(1100,18,'Violinkonzert Nr.3','D-dur',null);
insert into PIECE values
(1101,18,'Violinkonzert Nr.9','g-moll',null);
insert into PIECE values
(1102,20,'Missa in c `Grosse Messe''','c-moll','KV 427 (417a)');
insert into PIECE values
(1103,27,'Konzert f"ur Violine und Orchester D-dur','D-dur','Op.35');
insert into PIECE values
(1104,28,'Konzert f"ur Violine und Orchester e-moll','e-moll','Op.64');
insert into PIECE values
(1105,22,'Brandenburgisches Konzert Nr.1','F-dur','BWV 1046');
insert into PIECE values
(1106,22,'Brandenburgisches Konzert Nr.2','F-Dur','BWV 1047');
insert into PIECE values
(1107,22,'Brandenburgisches Konzert Nr.3','G-Dur','BWV 1048');
insert into PIECE values
(1108,22,'Brandenburgisches Konzert Nr.4','G-Dur','BWV 1049');
insert into PIECE values
(1109,22,'Brandenburgisches Konzert Nr.5','D-Dur','BWV 1050');
insert into PIECE values
(1110,22,'Brandenburgisches Konzert Nr.6','B-Dur','BWV 1051');
insert into PIECE values
(1111,29,'Symphonie Nr.8 `Die Unvollendete''','h-moll','D.759');
insert into PIECE values
(1112,29,'Symphonie Nr.5','B-Dur','D.485');
insert into PIECE values
(1113,29,'7 Walzer (aus Valses nobles op.77)',null,'D.969');
insert into PIECE values
(1114,29,'Deutscher Tanz','C-Dur','Op.33');
insert into PIECE values
(1115,30,'Die Kluge',null,null);
insert into PIECE values
(1116,30,'Der Mond',null,null);
insert into PIECE values
(1117,12,'The Love of the Three Oranges: Symponic Suite',null,'Op.33a');
insert into PIECE values
(1118,12,'Lieutenant Kije: Symponic Suite',null,'Op.60');
insert into PIECE values
(1119,12,'Symphonie Nr.7',null,'Op.131');
insert into PIECE values
(1120,12,'Symphonie Nr.6',null,'Op.111');
insert into PIECE values
(1121,12,'Symphonie Nr.4 (1930)',null,'Op.47');
insert into PIECE values
(1122,12,'Symphonie Nr.4 (1947)',null,'Op.112');
insert into PIECE values
(1123,12,'Symphonie Nr.2',null,'Op.40');
insert into PIECE values
(1124,12,'Symphonie Nr.3',null,'Op.44');
insert into PIECE values
(1125,31,'Symphonie Nr.9','Es-dur','Op.70');
insert into PIECE values
(1126,31,'Symphonie Nr.12 `1917''','d-moll','Op.112');
insert into PIECE values
(1127,13,'Madrigali Amorosi (Liebeslieder)',null,null);
insert into PIECE values
(1128,13,'Madrigali Guerrieri (Landskechtslieder)',null,null);
insert into PIECE values
(1129,32,'Missa di dadi',null,null);
insert into PIECE values
(1130,32,'Missa `Faisant regretz''',null,null);
insert into PIECE values
(1131,33,'Klaviertrio Nr.1','D-dur','Op.5');
insert into PIECE values
(1132,33,'Klaviertrio Nr.2','Fis-dur','Op.7');
insert into PIECE values
(1133,33,'Klavierquintett','Des-dur','Op.6');
insert into PIECE values
(1134,33,'Streichquintett','C-dur','Op.24');
insert into PIECE values
(1135,34,'Ungarische T"anze Nr.1,3,10,17-21',null,null);
insert into PIECE values
(1136,34,'Symphonie Nr.2','D-dur','Op.73');
insert into PIECE values
(1137,11,'`Messias'' (H"ohepunkte)',null,null);
insert into PIECE values
(1138,20,'`Salzburger Sinfonie'' Nr.1','D-dur','KV 136');
insert into PIECE values
(1139,20,'`Salzburger Sinfonie'' Nr.2','B-dur','KV 137');
insert into PIECE values
(1140,20,'`Salzburger Sinfonie'' Nr.3','F-dur','KV 138');
insert into PIECE values
(1141,20,'`Eine kleine Nachtmusik''','G-dur','KV 525');
insert into PIECE values
(1142,15,'Oboenkonzert a-moll','a-moll',null);
insert into PIECE values
(1143,35,'Oboenkonzert d-moll','d-moll',null);
insert into PIECE values
(1144,18,'Oboenkonzert c-moll','c-moll',null);
insert into PIECE values
(1145,36,'Oboenkonzert C-dur','C-dur',null);
insert into PIECE values
(1146,37,'Concerto grosso op.6/8','g-moll','Op.6/8');
insert into PIECE values
(1147,38,'Concerto a cinque','B-dur',null);
insert into PIECE values
(1148,39,'Sonata f-moll','f-moll',null);
insert into PIECE values
(1149,40,'Concerto grosso op.3/12','C-dur','Op.3/12');
insert into PIECE values
(1150,41,'Concerto grosso op.1/8','f-moll','Op.1/8');
insert into PIECE values
(1151,39,'Sonata G-dur','G-dur',null);
insert into PIECE values
(1152,37,'Concerto grosso D-dur','D-dur',null);
insert into PIECE values
(1153,13,'L''Orfeo',null,null);
insert into PIECE values
(1154,13,'Il Ritorno d''Ulisse in Patria',null,null);
insert into PIECE values
(1155,13,'L''Incoronazione di Poppea',null,null);
insert into PIECE values
(1156,42,'Intrada',null,null);
insert into PIECE values
(1157,43,'Von "uppiklichen Dingen',null,null);
insert into PIECE values
(1158,44,'Ballo francese',null,null);
insert into PIECE values
(1159,45,'L''armor, dona, ch''io te porto',null,null);
insert into PIECE values
(1160,null,'Mit ganzem Willen (ca.1460)',null,null);
insert into PIECE values
(1161,46,'Questo mostrarsi adirata di fore',null,null);
insert into PIECE values
(1162,null,'Passamezzo antico `Caminata'' (ca.1510)',null,null);
insert into PIECE values
(1163,null,'Es hett ein schwab ein t"ochterlein (ca.1530)',null,null);
insert into PIECE values
(1164,46,'Fortuna desperata',null,null);
insert into PIECE values
(1165,null,'Il marchese do Soluzzo (ca.1550)',null,null);
insert into PIECE values
(1166,null,'Merce te chiamo (15.Jh.)',null,null);
insert into PIECE values
(1167,47,'Madonna nui sapimo',null,null);
insert into PIECE values
(1168,46,'Maudit soit',null,null);
insert into PIECE values
(1169,null,'Passamezzo moderno (ca.1510)',null,null);
insert into PIECE values
(1170,47,'Chi la gagliarda',null,null);
insert into PIECE values
(1171,null,'Der heilig herr sanct Matheis (ca.1515)',null,null);
insert into PIECE values
(1172,45,'Io vorrei dio d''amore',null,null);
insert into PIECE values
(1173,50,'Il estoit une filette',null,null);
insert into PIECE values
(1174,null,'Rodrigo Martines (ca.1500)',null,null);
insert into PIECE values
(1175,null,'Dindirindin',null,null);
insert into PIECE values
(1176,32,'Scaramella',null,null);
insert into PIECE values
(1177,48,'Ti parti cor mio caro',null,null);
insert into PIECE values
(1178,49,'Bergerette Sans roch',null,null);

REMARK ************************************************************************
PROMPT "CD:"

CREATE TABLE CD(
	CDNO NUMBER(3)
		CONSTRAINT CD_KEY PRIMARY KEY
		CONSTRAINT CDNO_VALID CHECK(CDNO >= 0),
	NAME VARCHAR(45) NOT NULL,
	PRODUCER VARCHAR(17),
	DISCS NUMBER(2)
		CONSTRAINT DISCS_VALID CHECK(DISCS >= 1),
	MINUTES NUMBER(3)
		CONSTRAINT MINUTES_VALID CHECK(MINUTES >= 1)
);

PROMPT "   ... inserting data ..."

insert into CD
values (101,'H"andel: Feuerwerksmusik','zyx classic',1,60);
insert into CD
values (102,'Serge Prokofiev: Die Violinkonzerte','DG',1,49);
insert into CD
values (103,'Monteverdi: Vespro Della Beata Vergine 1610','Decca',2,100);
insert into CD
values (104,'Antonin Dvorak: Slawische T"anze','DG',1,70);
insert into CD
values (105,'Vivaldi: Le Quattro Stagioni (I Musici)','Philips',1,42);
insert into CD
values (106,'Leopold Mozart: Sinfonia D-Dur ...','Orfeo',1,44);
insert into CD
values (107,'Vivaldi: Die vier Jahreszeiten','zyx classic',1,64);
insert into CD
values (108,'Heinrich Ignaz Franz Biber: Battalia ...','Teldec',1,51);
insert into CD
values (109,'Telemann: Trompetenkonzerte','Nimbus Records',1,76);
insert into CD
values (110,'William Byrd: The Three Masses','Gimell',1,67);
insert into CD
values (111,'Mozart/Beethoven: Klassische Ouvert"uren','zyx classic',1,64);
insert into CD
values (112,'Monteverdi: Mass for four voices, ...','Hyperion',1,57);
insert into CD
values (113,'Bach: Violinkonzerte','Philips',1,61);
insert into CD
values (114,'Sergej Prokofiew: Symphonie Classique ...','DG',1,57);
insert into CD
values (115,'Gustav Mahler: Sinfonie Nr.4 G-dur','Saphir',1,57);
insert into CD
values (116,'Sibelius: Symphony No.2 ...','Philips',1,69);
insert into CD
values (117,'G.F.Handel: Orchesterwerke','Archiv Produktion',6,342);
insert into CD
values (118,'Berlioz: Symphonie Fantastique','Meastro',1,49);
insert into CD
values (119,'Berlioz: Harold in Italy','Decca',1,66);
insert into CD
values (120,'Prokofiev: Cinderella (Suite)','RCA',1,49);
insert into CD
values (121,'Mozart: Hornkonzerte','Philips',1,60);
insert into CD
values (122,'Hayden: Cellokonzerte','Philips',1,47);
insert into CD
values (123,'Telemann: 5 Violinkonzerte','Philips',1,51);
insert into CD
values (124,'Mozart: Grosse Messe in c-moll','Teldec',1,56);
insert into CD
values (125,'Tschaikowsky/Mendelssohn: Violinkonzerte','DG',1,58);
insert into CD
values (126,'Brandenburg Concertos No.1, 3, 4 and 6','Spectrum',1,72);
insert into CD
values (127,'Brandenburgische Konzerte','zyx classic',1,65);
insert into CD
values (128,'Schubert: Die Unvollendete','zyx classic',1,64);
insert into CD
values (129,'Carl Orff: Die Kluge / Der Mond','eurodisc',2,158);
insert into CD
values (130,'Prokofiev: Classical Symphony ...','EMI',1,53);
insert into CD
values (131,'Prokofiev: Les Symphonies','ERATO',4,280);
insert into CD
values (132,'Schostakowitsch: Symphonien 9+12','eurodisc',1,68);
insert into CD
values (133,'Claudio Monteverdi: Madrigali Amorosi ...','Intercord',1,39);
insert into CD
values (134,'Josquin Desprez: Missa di dadi ...','L''oiseau-Lyre',1,52);
insert into CD
values (135,'Wolf-Ferrari: Kammermusik','Dabringhaus/Grimm',2,118);
insert into CD
values (136,'Brahms: Ungarische T"anze','zyx classic',1,60);
insert into CD
values (137,'G. F. H"andel: `Messias'' (H"ohepunkte)','DD classique',1,53);
insert into CD
values (138,'Mozart: Salzburger Sinfonien','zyx classic',1,61);
insert into CD
values (139,'Oboenkonzerte','Da Camera Magna',1,43);
insert into CD
values (140,'Corelli,Albinoni,Scarlatti,Manfredini,...','zyx classic',1,66);
insert into CD
values (141,'Claudio Monteverdi: L''Orfeo, Ulisse, Poppea','Teldec',6,409);
insert into CD
values (142,'Schlager um 1500','Christophorus',1,63);

remark ************************************************************************

PROMPT "RECORDING:"

CREATE TABLE RECORDING(
	CDNO NUMBER(3)
		CONSTRAINT RECORDING_REF_CD REFERENCES CD,
	PNO  NUMBER(4)
		CONSTRAINT RECORDING_REF_PIECE REFERENCES PIECE,
	ORCHESTRA VARCHAR(45),
	CONDUCTOR VARCHAR(20),
	CONSTRAINT RECORDING_KEY PRIMARY KEY(CDNO, PNO)
);

PROMPT "   ... inserting data ..."

insert into RECORDING values
(101,1001,'London Festival Orchestra','Sidney Lark');
insert into RECORDING values
(101,1002,'London Festival Orchestra','Sidney Lark');
insert into RECORDING values
(101,1003,'London Festival Orchestra','Sidney Lark');
insert into RECORDING values
(101,1004,'Radio-Sinfonieorchester Stuttgart','Garcia Navarro');
insert into RECORDING values
(102,1005,'Chicago Symphony Orchestra','Claudio Abbado');
insert into RECORDING values
(102,1006,'Chicago Symphony Orchestra','Claudio Abbado');
insert into RECORDING values
(103,1007,'The Monteverdi Choir and Orchestra','John Eliot Gardiner');
insert into RECORDING values
(104,1008,'Symponie-Orchester des Bayerischen Rundfunks','Rafael Kubelik');
insert into RECORDING values
(104,1009,'Symponie-Orchester des Bayerischen Rundfunks','Rafael Kubelik');
insert into RECORDING values
(105,1010,'I Musici',null);
insert into RECORDING values
(105,1011,'I Musici',null);
insert into RECORDING values
(105,1012,'I Musici',null);
insert into RECORDING values
(105,1013,'I Musici',null);
insert into RECORDING values
(106,1014,'M"unchner Kammerorchester','Hans Stadlmair');
insert into RECORDING values
(106,1015,'M"unchner Kammerorchester','Hans Stadlmair');
insert into RECORDING values
(106,1016,null,null);
insert into RECORDING values
(107,1010,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(107,1011,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(107,1012,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(107,1013,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(107,1017,'Die Zagreber Solisten',null);
insert into RECORDING values
(107,1018,'Die Zagreber Solisten',null);
insert into RECORDING values
(107,1019,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(108,1020,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1021,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1022,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1023,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1024,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1025,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1026,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(108,1027,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(109,1028,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1029,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1030,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1031,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1032,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1033,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1034,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1035,'English String Orchestra','William Boughton');
insert into RECORDING values
(109,1036,'English String Orchestra','William Boughton');
insert into RECORDING values
(110,1037,'The Tallis Scholars','Peter Phillips');
insert into RECORDING values
(110,1038,'The Tallis Scholars','Peter Phillips');
insert into RECORDING values
(110,1039,'The Tallis Scholars','Peter Phillips');
insert into RECORDING values
(110,1040,'The Tallis Scholars','Peter Phillips');
insert into RECORDING values
(111,1041,'London Festival Orchestra','Kurt Redel');
insert into RECORDING values
(111,1042,'London Philharmonic Orchestra','Alfred Scholz');
insert into RECORDING values
(111,1043,'Radio Symphonieorchester','Anton Nanut');
insert into RECORDING values
(111,1044,'London Philharmonic Orchestra','Alfred Scholz');
insert into RECORDING values
(111,1045,'London Symphony Orchestra','Alfred Scholz');
insert into RECORDING values
(111,1046,'London Philharmonic Orchestra','Alfred Scholz');
insert into RECORDING values
(111,1047,'Radio Symphonieorchester','Anton Nanut');
insert into RECORDING values
(111,1048,'London Festival Orchestra','Kurt Redel');
insert into RECORDING values
(111,1049,'London Philharmonic Orchestra','Alfred Scholz');
insert into RECORDING values
(112,1050,'The Sixteen','Harry Christophers');
insert into RECORDING values
(112,1051,'The Sixteen','Harry Christophers');
insert into RECORDING values
(112,1052,'The Sixteen','Harry Christophers');
insert into RECORDING values
(112,1053,'The Sixteen','Harry Christophers');
insert into RECORDING values
(113,1054,'Les Solistes Romands','Arpad Gerecz');
insert into RECORDING values
(113,1055,'Les Solistes Romands','Arpad Gerecz');
insert into RECORDING values
(113,1056,'Les Solistes Romands','Arpad Gerecz');
insert into RECORDING values
(113,1057,'New Philharmonia Orchestra','Edo De Waart');
insert into RECORDING values
(114,1058,'Berliner Philharmoniker','Herbert von Karajan');
insert into RECORDING values
(114,1059,'Berliner Philharmoniker','Herbert von Karajan');
insert into RECORDING values
(115,1060,'Sinfonieorchester des S"udwestfunks','Michael Gielen');
insert into RECORDING values
(116,1061,'Boston Symphony Orchestra','Sir Colin Davis');
insert into RECORDING values
(116,1062,'Boston Symphony Orchestra','Sir Colin Davis');
insert into RECORDING values
(116,1063,'Boston Symphony Orchestra','Sir Colin Davis');
insert into RECORDING values
(116,1064,'Boston Symphony Orchestra','Sir Colin Davis');
insert into RECORDING values
(117,1065,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1066,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1002,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1067,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1068,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1069,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1070,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1071,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1072,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1073,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1074,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1075,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1076,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1077,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1078,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1079,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1080,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1001,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1003,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1081,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1082,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1083,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(117,1084,'The English Concert','Trevor Pinnock');
insert into RECORDING values
(118,1085,'The Cleveland Orchestra','Lorin Maazel');
insert into RECORDING values
(119,1086,'Orchestre symphonique de Montreal','Charles Dutoit');
insert into RECORDING values
(119,1087,'Orchestre symphonique de Montreal','Charles Dutoit');
insert into RECORDING values
(119,1088,'Orchestre symphonique de Montreal','Charles Dutoit');
insert into RECORDING values
(120,1089,'Saint Louis Symphony Orchestra','Leonard Slatkin');
insert into RECORDING values
(121,1090,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(121,1091,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(121,1092,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(121,1093,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(121,1094,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(122,1095,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(122,1096,'Academy of St.Martin-in-the-Fields','Sir Neville Marriner');
insert into RECORDING values
(123,1097,'Academy of St.Martin-in-the-Fields','Iona Brown');
insert into RECORDING values
(123,1098,'Academy of St.Martin-in-the-Fields','Iona Brown');
insert into RECORDING values
(123,1099,'Academy of St.Martin-in-the-Fields','Iona Brown');
insert into RECORDING values
(123,1100,'Academy of St.Martin-in-the-Fields','Iona Brown');
insert into RECORDING values
(123,1101,'Academy of St.Martin-in-the-Fields','Iona Brown');
insert into RECORDING values
(124,1102,'Concentus musicus Wien','Nikolaus Harnoncourt');
insert into RECORDING values
(125,1103,'Wiener Philharmoniker','Claudio Abbado');
insert into RECORDING values
(125,1104,'Wiener Philharmoniker','Claudio Abbado');
insert into RECORDING values
(126,1105,'Camerata W"urzburg','Prof. H. Reinartz');
insert into RECORDING values
(126,1107,'Camerata W"urzburg','Prof. H. Reinartz');
insert into RECORDING values
(126,1108,'Camerata W"urzburg','Prof. H. Reinartz');
insert into RECORDING values
(126,1110,'Camerata W"urzburg','Prof. H. Reinartz');
insert into RECORDING values
(127,1105,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(127,1106,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(127,1107,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(127,1109,'S"udwest-Studioorchester','Heribert M"unchner');
insert into RECORDING values
(128,1111,'Philharm. Festspielorchester','Vladimir Petroschoff');
insert into RECORDING values
(128,1112,'Philharm. Festspielorchester','Vladimir Petroschoff');
insert into RECORDING values
(128,1113,null,null);
insert into RECORDING values
(128,1114,'Symponisches Orchester Berlin','Carl-August B"unte');
insert into RECORDING values
(129,1115,'M"unchner Rundfunkorchester','Kurt Eichhorn');
insert into RECORDING values
(129,1116,'M"unchner Rundfunkorchester','Kurt Eichhorn');
insert into RECORDING values
(130,1117,'London Philharmonic Orchestra','Enrique Batiz');
insert into RECORDING values
(130,1058,'London Philharmonic Orchestra','Enrique Batiz');
insert into RECORDING values
(130,1118,'London Philharmonic Orchestra','Enrique Batiz');
insert into RECORDING values
(131,1058,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1059,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1119,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1120,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1121,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1122,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1123,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(131,1124,'Orchestre National De France','M. Rostropovitch');
insert into RECORDING values
(132,1125,'Staatl. Sinfonie-Orch. des Kultusmin.d.UdSSR','G. Roshdestwenskij');
insert into RECORDING values
(132,1126,'Staatl. Sinfonie-Orch. des Kultusmin.d.UdSSR','G. Roshdestwenskij');
insert into RECORDING values
(133,1127,'Die Prager Madrigalisten/Musica Antiqua Wien','Venhoda/Clemencic');
insert into RECORDING values
(133,1128,'Die Prager Madrigalisten/Musica Antiqua Wien','Venhoda/Clemencic');
insert into RECORDING values
(134,1129,'The Medieval Ensemble of London','P.Davies/T.Davies');
insert into RECORDING values
(134,1130,'The Medieval Ensemble of London','P.Davies/T.Davies');
insert into RECORDING values
(135,1131,'M"unchner Klaviertrio',null);
insert into RECORDING values
(135,1132,'M"unchner Klaviertrio',null);
insert into RECORDING values
(135,1133,'Leopolder-Quartett M"unchen',null);
insert into RECORDING values
(135,1134,'Leopolder-Quartett M"unchen',null);
insert into RECORDING values
(136,1135,'London Festival Orchestra','Julian Armstrong');
insert into RECORDING values
(136,1136,'London Festival Orchestra','Julian Armstrong');
insert into RECORDING values
(137,1137,'Westminster Choir / New York Philharmonic','Leonard Bernstein');
insert into RECORDING values
(138,1138,'Camerata Academia Salzburg','Hermann Abel');
insert into RECORDING values
(138,1139,'Camerata Academia Salzburg','Hermann Abel');
insert into RECORDING values
(138,1140,'Camerata Academia Salzburg','Hermann Abel');
insert into RECORDING values
(138,1141,'Camerata Academia Salzburg','Alexander v. Pitamic');
insert into RECORDING values
(139,1142,'Heidelberger Kammerorchester',null);
insert into RECORDING values
(139,1143,'Heidelberger Kammerorchester',null);
insert into RECORDING values
(139,1144,'Heidelberger Kammerorchester',null);
insert into RECORDING values
(139,1145,'Heidelberger Kammerorchester',null);
insert into RECORDING values
(140,1146,'Radio-Sinfonieorchester Stuttgart','Garcia Navarro');
insert into RECORDING values
(140,1147,'Die Zagreber Solisten',null);
insert into RECORDING values
(140,1148,null,null);
insert into RECORDING values
(140,1149,'Radio-Sinfonieorchester Stuttgart','Garcia Navarro');
insert into RECORDING values
(140,1150,'Radio-Sinfonieorchester Stuttgart','Garcia Navarro');
insert into RECORDING values
(140,1151,null,null);
insert into RECORDING values
(140,1152,'Die Zagreber Solisten',null);
insert into RECORDING values
(141,1153,'Monteverdi Ensemble/Opernhaus Z"urich','Nikolaus Harnocourt');
insert into RECORDING values
(141,1154,'Monteverdi Ensemble/Opernhaus Z"urich','Nikolaus Harnocourt');
insert into RECORDING values
(141,1155,'Monteverdi Ensemble/Opernhaus Z"urich','Nikolaus Harnocourt');
insert into RECORDING values
(142,1156,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1157,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1158,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1159,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1160,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1161,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1162,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1163,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1164,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1165,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1166,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1167,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1168,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1169,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1170,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1171,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1172,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1173,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1174,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1175,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1176,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1177,'Ensemble f"ur fr"uhe Musik Augsburg',null);
insert into RECORDING values
(142,1178,'Ensemble f"ur fr"uhe Musik Augsburg',null);

remark ************************************************************************

PROMPT "SOLOIST:"

CREATE TABLE SOLOIST(
	CDNO NUMBER(3),
	PNO NUMBER(4),
	NAME VARCHAR(21),
	INSTRUMENT VARCHAR(20),
	CONSTRAINT SOLOIST_REF_RECORDING FOREIGN KEY(CDNO, PNO) REFERENCES
				RECORDING,
	CONSTRAINT SOLOIST_KEY PRIMARY KEY(CDNO, PNO, NAME)
);

PROMPT "   ... inserting data ..."

insert into SOLOIST values (102,1005,'Shlomo Mintz','Violin');
insert into SOLOIST values (102,1006,'Shlomo Mintz','Violin');
insert into SOLOIST values (105,1010,'Pina Carmirelli','Violin');
insert into SOLOIST values (105,1011,'Pina Carmirelli','Violin');
insert into SOLOIST values (105,1012,'Pina Carmirelli','Violin');
insert into SOLOIST values (105,1013,'Pina Carmirelli','Violin');
insert into SOLOIST values (106,1014,'Jan Engel','Bagpipes');
insert into SOLOIST values (106,1014,'Max Engel','Drehleier');
insert into SOLOIST values (106,1015,'Kurt Moll','Bass');
insert into SOLOIST values (106,1016,'Jan Engel','Bagpipes');
insert into SOLOIST values (106,1016,'Max Engel','Drehleier');
insert into SOLOIST values (109,1028,'John Wallace','Trumpet');
insert into SOLOIST values (109,1029,'John Wallace','Trumpet');
insert into SOLOIST values (109,1030,'John Wallace','Trumpet');
insert into SOLOIST values (109,1031,'John Wallace','Trumpet');
insert into SOLOIST values (109,1032,'John Wallace','Trumpet');
insert into SOLOIST values (109,1033,'John Wallace','Trumpet');
insert into SOLOIST values (109,1034,'John Wallace','Trumpet');
insert into SOLOIST values (109,1035,'John Wallace','Trumpet');
insert into SOLOIST values (109,1036,'John Wallace','Trumpet');
insert into SOLOIST values (113,1054,'Arthur Grumiaux','Violin');
insert into SOLOIST values (113,1055,'Arthur Grumiaux','Violin');
insert into SOLOIST values (113,1056,'Arthur Grumiaux','Violin');
insert into SOLOIST values (113,1056,'Herman Krebbers','Violin');
insert into SOLOIST values (113,1057,'Arthur Grumiaux','Violin');
insert into SOLOIST values (113,1057,'Heinz Holliger','Oboe');
insert into SOLOIST values (115,1060,'Christine Whittlesey','Soprano');
insert into SOLOIST values (115,1060,'Wolfgang Hock','Violin');
insert into SOLOIST values (116,1064,'Laurence Thorstenberg','English Horn');
insert into SOLOIST values (119,1086,'Pinchas Zukerman','Viola');
insert into SOLOIST values (121,1090,'Alan Civil','Horn');
insert into SOLOIST values (121,1091,'Alan Civil','Horn');
insert into SOLOIST values (121,1092,'Alan Civil','Horn');
insert into SOLOIST values (121,1093,'Alan Civil','Horn');
insert into SOLOIST values (121,1094,'Alan Civil','Horn');
insert into SOLOIST values (122,1095,'Heinrich Schiff','Cello');
insert into SOLOIST values (122,1096,'Heinrich Schiff','Cello');
insert into SOLOIST values (123,1097,'Iona Brown','Violin');
insert into SOLOIST values (123,1098,'Iona Brown','Violin');
insert into SOLOIST values (123,1099,'Iona Brown','Violin');
insert into SOLOIST values (123,1100,'Iona Brown','Violin');
insert into SOLOIST values (123,1101,'Iona Brown','Violin');
insert into SOLOIST values (124,1102,'Krisztina Laki','Soprano');
insert into SOLOIST values (124,1102,'Zsuzsanna Denes','Soprano');
insert into SOLOIST values (124,1102,'Kurt Equiluz','Tenor');
insert into SOLOIST values (124,1102,'Robert Holl','Bass');
insert into SOLOIST values (125,1103,'Nathan Milstein','Violin');
insert into SOLOIST values (125,1104,'Nathan Milstein','Violin');
insert into SOLOIST values (128,1113,'Isabel Mourao','Piano');
insert into SOLOIST values (129,1115,'Lucia Popp','Soprano');
insert into SOLOIST values (129,1115,'Thomas Stewart','Bariton');
insert into SOLOIST values (129,1115,'Gottlob Frick','Bass');
insert into SOLOIST values (129,1116,'John van Kesteren','Tenor');
insert into SOLOIST values (129,1116,'Franz Crass','Bass');
insert into SOLOIST values (129,1116,'Fritz Strassner','Narrator');
insert into SOLOIST values (135,1134,'Wolfgang Sawallisch','Piano');
insert into SOLOIST values (139,1142,'Robin Williams','Oboe');
insert into SOLOIST values (139,1143,'Robin Williams','Oboe');
insert into SOLOIST values (139,1144,'Robin Williams','Oboe');
insert into SOLOIST values (139,1145,'Robin Williams','Oboe');
insert into SOLOIST values (140,1148,'Dubravka Tomsic','Piano');
insert into SOLOIST values (140,1151,'Dubravka Tomsic','Piano');