Create Table ARTIST(
    NAME VARCHAR(20),
    COUNTRY VARCHAR(20),

    PRIMARY KEY (NAME)
);

Create Table ART(
    ID SMALLINT,
    TYPE VARCHAR(20),
    CreatedYear SMALLINT,

    PRIMARY KEY(ID)
);

CREATE TABLE CREATES(
    NAME VARCHAR(20),
    ID SMALLINT,

    PRIMARY KEY(NAME,ID),
    FOREIGN KEY(NAME) REFERENCES ARTIST,
   FOREIGN KEY(ID) REFERENCES ART
);

INSERT INTO ART VALUES(1,'painting',1999);
INSERT INTO ART VALUES(2,'painting',1999);
INSERT INTO ART VALUES(3,'game',1999);
INSERT INTO ART VALUES(4,'painting',2000);
INSERT INTO ART VALUES(5,'painting',2000);

INSERT INTO ARTIST VALUES ('PETER','CHINA');
INSERT INTO ARTIST VALUES ('JOHN','AMERICA');
INSERT INTO ARTIST VALUES ('SAD','AMERICA');

INSERT INTO CREATES VALUES('PETER',1);
INSERT INTO CREATES VALUES('PETER',3);
INSERT INTO CREATES VALUES('PETER',4);
INSERT INTO CREATES VALUES('JOHN',5);
INSERT INTO CREATES VALUES ('SAD', 2);