CREATE TABLE authors (
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  nationality varchar(100) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY name (name)
) TYPE=MyISAM ;

CREATE TABLE books (
  title varchar(255) NOT NULL default '',
  author_id int(11) NOT NULL default '0',
  price decimal(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (title,author_id)
) TYPE=MyISAM;