create table movie (
movieID number(5) not null primary key,
title varchar2(100),
director varchar2(100),
releasedate date,
leadActor varchar2(100)
);

create table rental_copy (
inventoryID number(5) not null primary key,
movieid number(5) not null,
mediaformat varchar2(50),
foreign key (movieid) references movie(movieID)
);


create table rental (
rentalID number(5) not null primary key,
inventoryID number(5) not null,
rentaldate date not null,
customerID number(5) not null,
returnDate Date,
check (rentaldate < returndate),
foreign key (inventoryid) references rental_copy(inventoryid)
);