text: DROP TABLE MASTERPIECE if exists;
  DROP TABLE MUSIC_ALBUM if exists;
  DROP TABLE MOVIE if exists;
  
  CREATE TABLE MASTERPIECE  (
      MASTERPIECE_ID BIGINT IDENTITY NOT NULL PRIMARY KEY ,    
      NAME VARCHAR(128) NOT NULL ,
      YEAR INT NOT NULL,
      GENRE CHAR(10) NOT NULL
  );
  
  CREATE TABLE MUSIC_ALBUM  (
      ALBUM_ID BIGINT IDENTITY NOT NULL PRIMARY KEY,
      MASTERPIECE_ID BIGINT NOT NULL,
      BAND VARCHAR(128) NOT NULL,
      constraint ALBUM_MASTERPIECE_ID_FK foreign key (MASTERPIECE_ID)
      references MASTERPIECE(MASTERPIECE_ID)
  );
  
  CREATE TABLE MOVIE  (
      MOVIE_ID BIGINT IDENTITY NOT NULL PRIMARY KEY,
      MASTERPIECE_ID BIGINT NOT NULL,
      REALISATOR VARCHAR(128) NOT NULL,
      ACTORS VARCHAR(512) NOT NULL,
      constraint MOVIE_MASTERPIECE_ID_FK foreign key (MASTERPIECE_ID)
      references MASTERPIECE(MASTERPIECE_ID)
  ) ;
  
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (1, 'Help!', 1965, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (2, 'Star Wars: Episode IV - A New Hope!', 1977, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (3, 'Outlandos d''Amour!', 1978, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (4, 'The Wall', 1979, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (5, 'War', 1983, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (6, 'Star Wars : Episode VI - Return of the Jedi', 1983, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (7, 'Total Recal', 1990, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (8, 'Achtung Baby', 1991, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (9, 'Nevermind', 1991, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (10, 'Black Album', 1991, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (11, 'Terminator 2 : Judgement Day', 1991, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (12, 'Pulp Fiction', 1994, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (13, 'OK Computer', 1997, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (14, 'Showbiz', 1999, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (15, 'The Lord of the Rings: The Return of the King', 2003, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (16, 'The Resistance', 2009, 'Music');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (17, 'Inception', 2010, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (18, 'The Dark Knight Rises', 2012, 'Movie');
  Insert into MASTERPIECE (MASTERPIECE_ID,NAME,YEAR,GENRE) values (19, 'Messina', 2012, 'Music');
  
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (1, 1, 'The Beatles');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (2, 3, 'The Police');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (3, 4, 'Pink Floyd');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (4, 5, 'U2');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (5, 8, 'U2');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (6, 9, 'Nirvana');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (7, 10, 'Metallica');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (8, 13, 'Radiohead');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (9, 14, 'Muse');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (10, 16, 'Muse');
  Insert into MUSIC_ALBUM (ALBUM_ID,MASTERPIECE_ID,BAND) values (11, 19, 'Saez');
  
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (1, 2, 'George Lucas', 'Mark Hamill, Harrison Ford, Carrie Fisher');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (2, 6, 'Richard Marquand', 'Mark Hamill, Harrison Ford, Carrie Fisher');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (3, 7, 'Paul Verhoeven', 'Arnold Schwarzenegger, Sharon Stone');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (4, 11, 'James Cameron', 'Arnold Schwarzenegger');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (5, 12, 'Quentin Tarantino', 'John Travolta, Samuel L. Jackson, Uma Thurman');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (6, 15, 'Peter Jackson', 'Elijah Wood, Sean Astin');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (7, 17, 'Christopher Nolan', 'Leonardo DiCaprio, Marion Cotillard');
  Insert into MOVIE (MOVIE_ID,MASTERPIECE_ID,REALISATOR,ACTORS) values (8, 18, 'Christopher Nolan', 'Christian Bale, Gary Oldman');
  