CREATE TABLE konto(nummer INTEGER PRIMARY KEY, stand DECIMAL(5,2) NOT NULL);
CREATE TABLE inhaber(name VARCHAR(20) NOT NULL, nummer INTEGER NOT NULL, PRIMARY KEY(name, nummer));

INSERT INTO konto VALUES(12345678, 5000);
INSERT INTO konto VALUES(11111111, 100);

INSERT INTO inhaber VALUES("John Doe", 12345678);
INSERT INTO inhaber VALUES("John Doe", 11111111);
INSERT INTO inhaber VALUES("Barnie Bar", 11111111);