مشكلة جديدة في الجداول

السلام عليكم ورحمة الله

مشكلة جديدة شباب

لو تكرمتم وجربتم تكوين هذه الجداول

وكيف حل المشكلة

CREATE TABLE RATING33(

RATING_ID NUMBER(3)PRIMARY KEY,

RATING_NAME VARCHAR2(40) NOT NULL);

CREATE TABLE RATING333(

RATING_ID NUMBER(3),

RATING2_ID NUMBER(3),

RATING_NAME VARCHAR2(40) NOT NULL,

CONSTRAINT RATING_PK PRIMARY KEY(RATING_ID,RATING2_ID),

CONSTRAINT RATING_FK FOREIGN KEY (RATING_ID)REFERENCES RATING33(RATING_ID));

CREATE TABLE BOOK33(

RATING_ID NUMBER(3),

RATING2_ID NUMBER(3),

BOOK_NAME VARCHAR2(40),

AUTHOR VARCHAR2(40),

AUTHOR2 VARCHAR2(40),

AUTHOR3 VARCHAR2(40),

AUTHOR4 VARCHAR2(40),

AUTHOR5 VARCHAR2(40),

PUBLISHER VARCHAR2(40),

ISSUE date,

PARTS NUMBER(2),

PRINTING_NO NUMBER(3),

COPYS NUMBER(3),

LANG_CODE NUMBER(2),

PRINT_ID NUMBER(2),

PROVIDER_ID NUMBER(3),

PROVIDER_NAME VARCHAR2(40),

SUPPPLY_ID NUMBER(2),

NOTE VARCHAR2(250),

CONSTRAINT BOOK_PK PRIMARY KEY(RATING_ID,RATING2_ID),

CONSTRAINT BOOK_RAT_FK1 FOREIGN KEY (RATING_ID) REFERENCES RATING33(RATING_ID),

CONSTRAINT BOOK_RAT_FK2 FOREIGN KEY (RATING2_ID) REFERENCES RATING333(RATING2_ID));

*******************************************************

رسالة الخطأ:

ERROR at line 23:

ORA-02270: no matching unique or primary key for this column-list