Notes

CREATE TABLE membership(
mem_num INT PRIMARY KEY NOT NULL,
mem_fname VARCHAR NOT NULL,
mem_lname VARCHAR NOT NULL,
mem_street VARCHAR NOT NULL,
mem_city VARCHAR NOT NULL,
mem_state VARCHAR NOT NULL,
mem_zip INT NOT NULL,
mem_balance INT NOT NULL);

CREATE TABLE rental(
rent_num INT PRIMARY KEY NOT NULL,
rent_date DATE NOT NULL,
mem_num INT REFERENCES membership(mem_num));

CREATE TABLE price(
price_code INT PRIMARY KEY NOT NULL,
price_description VARCHAR NOT NULL,
price_rentfee NUMBER NOT NULL,
price_dailylatefee NUMBER NOT NULL);

CREATE TABLE movie(
movie_num INT PRIMARY KEY NOT NULL,
movie_title VARCHAR NOT NULL,
movie_year DATE NOT NULL,
movie_cost FLOAT NOT NULL,
movie_genre VARCHAR NOT NULL,
price_code INT REFERENCES price(price_code));

CREATE TABLE video(
vid_num INT PRIMARY KEY NOT NULL,
vid_indate DATE NOT NULL,
movie_num INT REFERENCES movie(movie_num));

CREATE TABLE DETAILRENTAL(
rent_num INT NOT NULL,
vid_num INT NOT NULL,
detail_fee NUMBER NOT NULL,
detail_date DATE NOT NULL,
detail_returndate DATE NOT NULL,
detail_dailylatefee NUMBER NOT NULL,
CONSTRAINT pk_detailrental PRIMARY KEY (rent_num,vid_num),
CONSTRAINT fk_detailrental1 FOREIGN KEY (rent_num) REFERENCES rental(rent_num),
CONSTRAINT fk_detailrental2 FOREIGN KEY (vid_num) REFERENCES video(vid_num)
);