CREATE SCHEMA EBMUSIC;

CREATE TABLE EBMUSIC.ALBUM
  (ALBUMID BIGINT NOT NULL,
   ARTISTID BIGINT,
   GENRE VARCHAR( 250 ),
   TITLE VARCHAR( 250 ));

ALTER TABLE EBMUSIC.ALBUM
  ADD CONSTRAINT ALBUMPK PRIMARY KEY (ALBUMID);

CREATE TABLE EBMUSIC.SONG
  (SONGID BIGINT NOT NULL,
   TITLE VARCHAR( 250 ),
   ALBUMID BIGINT);

ALTER TABLE EBMUSIC.SONG
  ADD CONSTRAINT SONGSPK PRIMARY KEY (SONGID);