SQL & PL/SQL

Hi ,

Am creating a table based on some integrity constraints, but it's not working.

CREATE TABLE member
(
member_id NUMBER(10),
last_name VARCHAR2(25) NOT NULL,
first_name VARCHAR2(25),
address VARCHAR2(100),
city VARCHAR2(30),
phone VARCHAR2(15),
join_date DATE
);

alter table member add constraint mem_pk primary key(member_id);

desc member

CREATE TABLE title
(
title_id NUMBER(10),
title VARCHAR2(60) NOT NULL,
description VARCHAR2(400) NOT NULL,
rating VARCHAR2(4)CONSTRAINT rat_chk CHECK(rating IN('G','PG','R','NC17','NR')),
category VARCHAR2(20) CONSTRAINT cat_chk CHECK(category IN('DRAGMA','COMEDY','ACTION','CHILD','SCIFI','DOCUMENTRY')),
release_date DATE
);

alter table title add constraint titid_pk primary key(title_id);

desc title

CREATE TABLE title_copy
(
copy_id NUMBER(10),
title_id NUMBER(10),
status VARCHAR2(15)NOT NULL CONSTRAINT stat_chk CHECK(status IN('AVAILABLE','DESTROYED','RENTED','RESERVED')),
CONSTRAINT cpytitid_pk PRIMARY KEY(copy_id,title_id),
CONSTRAINT tit_fk FOREIGN KEY(title_id) REFERENCES title(title_id)
)

desc title_copy

CREATE TABLE rental
(
book_date DATE DEFAULT sysdate,
member_id NUMBER(10),
copy_id NUMBER(10),
act_ret_date DATE,
exp_ret_date DATE DEFAULT sysdate+2,
title_id NUMBER(10),
CONSTRAINT bkmemcpytit_pk PRIMARY KEY(book_date,member_id,copy_id,title_id),
CONSTRAINT memcpytit_fk FOREIGN KEY(member_id) REFERENCES member(member_id)),
CONSTRAINT memcpytt_fk FOREIGN KEY(copy_id) REFERENCES title_copy(copy_id),
CONSTRAINT memcpyttt_fk FOREIGN KEY(title_id) REFERENCES title_copy(title_id)
)


I am struggle with rental table .. Please help me.

Error:

Error report:
SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 - "no matching unique or primary key for this column-list"
*Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
gives a column-list for which there is no matching unique or primary
key constraint in the referenced table.
*Action: Find the correct column names using the ALL_CONS_COLUMNS
catalog view