Hi all,

here is the script I wrote for myself, according to the puzzle specification. It also contains some sample data.

CREATE TABLE SPECIES(
  spcid INTEGER primary key,
  spcname VARCHAR(100)
)
GO

CREATE TABLE ALIEN_MISSILE(
  missile_id INTEGER primary key,
  missile_name VARCHAR(100),
  descr VARCHAR(400)
)
GO

CREATE TABLE ALIEN_CAPABILITY(
  spcid INTEGER,
  missile_id INTEGER,
  constraint fk_alien_capability_species foreign key (spcid) references SPECIES(spcid),
  constraint fk_alien_capability_alien_missile foreign key (missile_id) references ALIEN_MISSILE(missile_id)
)
GO

CREATE TABLE ANTI_MISSILE(
  antim_id INTEGER primary key,
  anitm_name VARCHAR(100),
  anitm_descr VARCHAR(400)
)
GO

CREATE TABLE DEFUSE_CAPABILITY(
  antim_id INTEGER,
  missile_id INTEGER,
  constraint fk_defuse_capability_anti_missile foreign key (antim_id) references ANTI_MISSILE(antim_id),
  constraint fk_defuse_capability_alien_missile foreign key (missile_id)  references ALIEN_MISSILE(missile_id)
)
GO

SET NOCOUNT ON
INSERT INTO SPECIES (spcid, spcname) VALUES (1, 'X')
INSERT INTO SPECIES (spcid, spcname) VALUES (2, 'Y')


INSERT INTO ALIEN_MISSILE(missile_id, missile_name, descr) VALUES (1, 'M-1', 'Missile 1')
INSERT INTO ALIEN_MISSILE(missile_id, missile_name, descr) VALUES (2, 'M-2', 'Missile 2')
INSERT INTO ALIEN_MISSILE(missile_id, missile_name, descr) VALUES (3, 'M-3', 'Missile 3')
INSERT INTO ALIEN_MISSILE(missile_id, missile_name, descr) VALUES (4, 'M-4', 'Missile 4')


INSERT INTO ALIEN_CAPABILITY(spcid, missile_id) VALUES (1, 1)
INSERT INTO ALIEN_CAPABILITY(spcid, missile_id) VALUES (1, 2)
INSERT INTO ALIEN_CAPABILITY(spcid, missile_id) VALUES (1, 3)

INSERT INTO ALIEN_CAPABILITY(spcid, missile_id) VALUES (2, 1)
INSERT INTO ALIEN_CAPABILITY(spcid, missile_id) VALUES (2, 4)


INSERT INTO ANTI_MISSILE(antim_id, anitm_name, anitm_descr) VALUES (1, 'AM-1', 'Anti-missile 1')
INSERT INTO ANTI_MISSILE(antim_id, anitm_name, anitm_descr) VALUES (2, 'AM-2', 'Anti-missile 2')
INSERT INTO ANTI_MISSILE(antim_id, anitm_name, anitm_descr) VALUES (3, 'AM-3', 'Anti-missile 3')
INSERT INTO ANTI_MISSILE(antim_id, anitm_name, anitm_descr) VALUES (4, 'AM-4', 'Anti-missile 4')


INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (1, 1)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (1, 2)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (1, 3)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (1, 4)

INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (2, 1)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (2, 2)

INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (3, 1)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (3, 2)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (3, 3)

INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (4, 1)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (4, 2)
INSERT INTO DEFUSE_CAPABILITY(antim_id, missile_id) VALUES (4, 4)

GO

Regards,

Goce.