The P7.65 have total 6 tables ..This below SL Create table commands are created the tabled as per the problem statement with strictly applying the enforcement rules..

Answer for Table A) Table 1 for MEMBERSHIP is below It have the one primary key called MEM_NUM:

CREATE TABLE MEMBERSHIP (
MEM_NUM   CHAR(3)   PRIMARY KEY,
MEM_FNAME   VARCHAR2(15)   NOT NULL,
MEM_LNAME   VARCHAR2(15)   NOT NULL,
MEM_STREET   VARCHAR2(40),
MEM_CITY   VARCHAR2(30),
MEM_STATE   CHAR(2),
MEM_ZIP   VARCHAR2(10),
MEM_BALANCE   CHAR(2));


Answer for Table B) Table 2 for RENTAL is below It have the one primary key called RENT_NUM:

CREATE TABLE RENTAL (
RENT_NUM   CHAR(4)   PRIMARY KEY,
RENT_DATE   DATE,
MEM_NUM   CHAR(3)
FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP);

Answer for Table C) Table 3 for PRICE is below It have the one primary key called PRICE_CODE:

CREATE TABLE PRICE (
PRICE_CODE   CHAR(1)   PRIMARY KEY,
PRICE_DESCRIPTION   VARCHAR2(15),
PRICE_RENTFEE   NUMBER(2,1),
PRICE_DAILYLATEFEE   NUMBER(2,1));

Answer for Table D) Table 4 for MOVIE is below It have the one primary key called MOVIE_NUM:

CREATE TABLE MOVIE (
MOVIE_NUM   CHAR(4)   PRIMARY KEY,
MOVIE_TITLE   VARCHAR(40),
MOVIE_YEAR   CHAR(4),
MOVIE_COST   NUMBER(4,2),
MOVIE_GENRE   VARCHAR2(15),
PRICE_CODE   CHAR(1),
FOREIGN KEY (PRICE_CODE) REFERENCES PRICE);

Answer for Table E) Table 5 for VIDEO is below It have the one primary key called VID_NUM:

CREATE TABLE VIDEO (
VID_NUM   CHAR(5)   PRIMARY KEY,
VID_INDATE   DATE,
MOVIE_NUM   CHAR(4),
FOREIGN KEY (MOVIE_NUM) REFERENCES MOVIE);

Answer for Table F) Table 5 for DETAILRENTAL is below It have the one primary key called RENT_NUM,VID_NUM:

CREATE TABLE DETAILRENTAL (
RENT_NUM   CHAR(4),
VID_NUM   CHAR(5),
DETAIL_FEE   NUMBER(2,1),
DETAIL_DUEDATE   DATE,
DETAIL_RETURNDATE   DATE,
DETAIL_DAILYLATEFEE   CHAR(1),
PRIMARY KEY (RENT_NUM, VID_NUM)
FOREIGN KEY (RENT_NUM) REFERENCES RENT,
FOREIGN KEY (VID_NUM) REFERENCES VIDEO);