insert into place values ( 1 , 'Manchester' , 'England' );
insert into place values ( 2 , 'Edinburgh' , 'Scotland' );
insert into place values ( 3 , 'Salzburg' , 'Austria' );
insert into place values ( 4 , 'New York' , 'USA' );
insert into place values ( 5 , 'Birmingham' , 'England' );
insert into place values ( 6 , 'Glasgow' , 'Scotland' );
insert into place values ( 7 , 'London' , 'England' );
insert into place values ( 8 , 'Chicago' , 'USA' );
insert into place values ( 9 , 'Amsterdam' , 'Netherlands' );
insert into musician values ( 1 , 'Fred Bloggs' , '2-Jan-1948',NULL , 1, 2);
insert into musician values ( 2, 'John Smith' , '3-Mar-1950',NULL , 3, 4);
insert into musician values ( 3 , 'Helen Smyth' , '8-Aug-1948',NULL , 4,5);
insert into musician values ( 4 , 'Harriet Smithson' , '9-May-1909','20-Sep-1980' , 5, 6);
insert into musician values ( 5 , 'James First' , '10-Jun-1965',NULL , 7, 7);
insert into musician values ( 6 , 'Theo Mengel' , '12-Aug-1948',NULL , 7, 1);
insert into musician values ( 7 , 'Sue Little' , '21-Feb 1945',NULL , 8, 9);
insert into musician values ( 8 , 'Harry Forte' , '28-Feb-1951',NULL , 1,8);
insert into musician values ( 9 , 'Phil Hot' , '30-Jun-1942',NULL , 2, 7);
insert into musician values ( 10 , 'Jeff Dawn' , '12-Dec-1949',NULL ,3 ,6);
insert into musician values ( 11 , 'Rose Spring' , '25-May-1948',NULL ,4 ,5);
insert into musician values ( 12 , 'Davis Heavan' , '3-Oct-1975',NULL , 5, 4);
insert into musician values ( 13, 'Lovely Time' , '28-Dec-1948',NULL , 6, 3);
insert into musician values ( 14 , 'Alan Fluff' , '15-Jan-1935','15-May-1997' , 7,2);
insert into musician values ( 15 , 'Tony Smythe' , '2-Apr-1932',NULL , 8, 1);
insert into musician values ( 16 , 'James Quick' , '8-Aug-1924',NULL , 9, 2);
insert into musician values ( 17 , 'Freda Miles' , '4-Jul-1920',NULL , 9, 3);
insert into musician values ( 18 , 'Elsie James' , '6-May-1947',NULL , 8, 5);
insert into musician values ( 19 , 'Andy Jones' , '8-Oct-1958',NULL , 7, 6);
insert into musician values ( 20 , 'Louise Simpson' , '10-Jan-1948','11-Feb-1998' , 6, 6);
insert into musician values ( 21 , 'James Steeple' , '10-Jan-1947',NULL , 5, 6);
insert into musician values ( 22 , 'Steven Chaytors' , '11-Mar-1956',NULL , 6, 7);
insert into composer values (1 , 1, 'jazz');
insert into composer values ( 2, 3, 'classical');
insert into composer values ( 3, 5, 'jazz');
insert into composer values ( 4, 7, 'classical');
insert into composer values ( 5, 9, 'jazz');
insert into composer values (6 , 11, 'rock');
insert into composer values (7 , 13, 'classical');
insert into composer values ( 8, 15, 'jazz');
insert into composer values ( 9, 17, 'classical');
insert into composer values ( 10 , 19, 'jazz');
insert into composer values ( 11, 10, 'rock');
insert into composer values ( 12, 8, 'jazz');
insert into performer values ( 1, 2, 'violin','classical' );
insert into performer values ( 2, 4, 'viola','classical' );
insert into performer values ( 3, 6, 'banjo','jazz' );
insert into performer values ( 4, 8, 'violin','classical' );
insert into performer values ( 5, 12, 'guitar','jazz' );
insert into performer values ( 6, 14, 'violin','classical' );
insert into performer values ( 7, 16, 'trumpet','jazz' );
insert into performer values ( 8, 18, 'viola','classical' );
insert into performer values ( 9, 20, 'bass','jazz' );
insert into performer values ( 10, 2, 'flute','jazz' );
insert into performer values ( 11, 20, 'cornet','jazz' );
insert into performer values ( 12, 6, 'violin','jazz' );
insert into performer values ( 13, 8, 'drums','jazz' );
insert into performer values ( 14, 10, 'violin','classical' );
insert into performer values ( 15, 12, 'cello','classical' );
insert into performer values ( 16, 14, 'viola','classical' );
insert into performer values ( 17, 16, 'flute','jazz' );
insert into performer (perf_no, perf_is, instrument) values ( 18, 18, 'guitar' );
insert into performer values ( 19, 20, 'trombone','jazz' );
insert into performer values ( 20, 3, 'horn','jazz' );
insert into performer values ( 21, 5, 'violin','jazz' );
insert into performer values ( 22, 7, 'cello','classical' );
insert into performer values ( 23, 2, 'bass','jazz' );
insert into performer values ( 24, 4, 'violin','jazz' );
insert into performer values ( 25, 6, 'drums','classical' );
insert into performer values ( 26, 8, 'clarinet','jazz' );
insert into performer values ( 27, 10, 'bass','jazz' );
insert into performer values ( 28, 12, 'viola','classical' );
insert into performer values ( 29, 18, 'cello','classical' );
insert into band values ( 1,'ROP',5 ,'classical','1-Jan-1930',11 );
insert into band values ( 2,'AASO',6 ,'classical','',10 );
insert into band values ( 3,'The J Bs',8 ,'jazz','',12 );
insert into band values ( 4,'BBSO', 9,'classical','',21 );
insert into band values ( 5,'The left Overs',2 ,'jazz','', 8);
insert into band values ( 6,'Somebody Loves this',1 ,'jazz','', 6);
insert into band values ( 7,'Oh well', 4,'classical','',3 );
insert into band values ( 8,'Swinging strings',4 ,'classical','', 7);
insert into band values ( 9,'The Rest', 9,'jazz','', 16);
insert into composition values ( 1, '17-Jun-1975','Opus 1', 1);
insert into composition values ( 2, '21-Jul-1976','Here Goes', 2);
insert into composition values ( 3, '14-Dec-1981','Valiant Knight', 3);
insert into composition values ( 4, '12-Jan-1982','Little Piece', 4);
insert into composition values ( 5, '13-Mar-1985','Simple Song', 5);
insert into composition values ( 6, '14-Apr-1986','Little Swing Song', 6);
insert into composition values ( 7, '13-May-1987','Fast Journey', 7);
insert into composition values ( 8, '14-Feb-1976','Simple Love Song', 8);
insert into composition values ( 9, '21-Jan-1982','Complex Rythms', 9);
insert into composition values ( 10, '23-Feb-1985','Drumming Rythms', 9);
insert into composition values ( 11, '18-Mar-1978','Fast Drumming', 8);
insert into composition values ( 12, '13-Aug-1984','Slow Song', 7);
insert into composition values ( 13, '14-Sep-1968','Blue Roses', 6);
insert into composition values ( 14, '15-Nov-1983','Velvet Rain', 5);
insert into composition values ( 15, '16-May-1982','Cold Wind', 4);
insert into composition values ( 16, '18-Jun-1983','After the Wind Blows', 3);
insert into composition values ( 17, NULL,'A Simple Piece', 2);
insert into composition values ( 18, '12-Jan-1985','Long Rythms', 1);
insert into composition values ( 19, '12-Feb-1988','Eastern Wind', 1);
insert into composition values ( 20, NULL,'Slow Symphony Blowing', 2);
insert into composition values ( 21, '12-Jul-1990','A Last Song', 6);
insert into has_composed values (1 ,1 );
insert into has_composed values (3 ,2 );
insert into has_composed values (5 ,3 );
insert into has_composed values (7 ,4 );
insert into has_composed values (9 ,5 );
insert into has_composed values (11 , 6);
insert into has_composed values (12 , 7);
insert into has_composed values (1 , 8);
insert into has_composed values (7 , 9);
insert into has_composed values (9 , 10);
insert into has_composed values (2 , 11);
insert into has_composed values ( 4, 12);
insert into has_composed values ( 3, 13);
insert into has_composed values ( 5, 14);
insert into has_composed values (6 , 15);
insert into has_composed values (8 , 16);
insert into has_composed values (10 , 17);
insert into has_composed values (3 , 18);
insert into has_composed values ( 12, 19);
insert into has_composed values ( 4, 20);
insert into has_composed values ( 6, 21);
insert into has_composed values ( 5, 13);
insert into has_composed values ( 3, 14);
insert into concert values ( 1,'Bridgewater Hall',1 ,'6-Jan-1995', 21);
insert into concert values ( 2,'Bridgewater Hall',1 ,'8-May-1996', 3);
insert into concert values ( 3,'Usher Hall',2 ,'3-Jun-1995', 3);
insert into concert values ( 4,'Assembly Rooms',2 ,'20-Sep-1997',21 );
insert into concert values ( 5,'Festspiel Haus',3 ,'21-Feb-1995',8 );
insert into concert values ( 6,'Royal Albert Hall',7 ,'12-Apr-1993',8 );
insert into concert values ( 7,'Concertgebouw',9 ,'14-May-1993', 8);
insert into concert values ( 8,'Metropolitan',4 ,'15-Jun-1997',21 );
insert into plays_in values ( 1, 1);
insert into plays_in values ( 3, 1);
insert into plays_in values ( 4, 1);
insert into plays_in values ( 5, 1);
insert into plays_in values ( 6, 1);
insert into plays_in values ( 7, 1);
insert into plays_in values ( 8, 1);
insert into plays_in values ( 10, 2);
insert into plays_in values ( 12, 2);
insert into plays_in values ( 13, 2);
insert into plays_in values ( 14, 2);
insert into plays_in values ( 15, 2);
insert into plays_in values ( 17, 2);
insert into plays_in values ( 18, 2);
insert into plays_in values ( 19, 3);
insert into plays_in values ( 20, 3);
insert into plays_in values ( 21, 4);
insert into plays_in values ( 22, 4);
insert into plays_in values ( 23, 4);
insert into plays_in values ( 25, 5);
insert into plays_in values ( 26, 6);
insert into plays_in values ( 27, 6);
insert into plays_in values (28 , 7);
insert into plays_in values (29 , 7);
insert into plays_in values ( 1, 7 );
insert into plays_in values ( 4, 7);
insert into plays_in values ( 6, 7);
insert into plays_in values ( 8, 7);
insert into plays_in values ( 14, 8);
insert into plays_in values ( 15, 8);
insert into plays_in values ( 28, 8);
insert into performance values ( 1, 1, 1, 21, 1);
insert into performance values ( 2, 1, 3, 21, 1);
insert into performance values ( 3, 1, 5, 21, 1);
insert into performance values ( 4, 1, 2, 1, 2);
insert into performance values ( 5, 2, 4, 21, 2);
insert into performance values ( 6, 2, 6, 21, 2);
insert into performance values ( 7, 4, 19, 9, 3);
insert into performance values ( 8, 4, 20,10, 3);
insert into performance values ( 9, 5, 12,10, 4);
insert into performance values ( 10, 5, 13,11, 4);
insert into performance values ( 11, 3, 5,13 , 5);
insert into performance values ( 12, 3, 6,13 , 5);
insert into performance values ( 13, 3, 7,13 , 5);
insert into performance values ( 14, 6, 20,14 , 6);
insert into performance values ( 15, 8, 12,15 , 7);
insert into performance values ( 16, 9, 16,21 , 8);
insert into performance values ( 17, 9, 17,21 , 8);
insert into performance values ( 18, 9, 18,21 , 8);
insert into performance values ( 19, 9, 19,21 , 8);
insert into performance values ( 20, 4, 12,10 , 3);


