CREATE TABLE BAND (
    ID   INTEGER      PRIMARY KEY
                      UNIQUE
                      NOT NULL,
    Name STRING (100) 
);


CREATE TABLE Musiker (
    ID   INTEGER PRIMARY KEY
                 UNIQUE
                 NOT NULL,
    Name STRING
);


CREATE TABLE LNK_BAND_MBR (
    ID         INTEGER PRIMARY KEY
                       UNIQUE
                       NOT NULL,
    ID_Band    INTEGER REFERENCES BAND (ID) MATCH SIMPLE,
    ID_Musiker INTEGER REFERENCES Musiker (ID) MATCH SIMPLE
);
