use music;

DROP TABLE IF EXISTS cd;
DROP TABLE IF EXISTS artist;

CREATE TABLE artist (
   artist_id int(5) NOT NULL,
   artist_name varchar(50),
   PRIMARY KEY (artist_id)
);

CREATE TABLE cd (
   cd_id int(5) NOT NULL,
   cd_name varchar(50),
   artist_id int(5) NOT NULL,
   PRIMARY KEY (cd_id),
   KEY artist (artist_id)
);

INSERT INTO artist VALUES
  (1,  'Leo Kottke'),
  (2,  'Wizz Jones'),
  (3,  'Altan'),
  (4,  'John Fahey');

INSERT INTO cd VALUES
  (1, 'Mudlark', 1),
  (2, 'My Feet Are Smiling', 1),
  (3, 'Lucky The Man', 2),
  (4, 'The Blue Idol', 3),
  (5, 'Return of the Repressed', 4);

SELECT cd_name, artist_name FROM cd NATURAL JOIN artist;