For the JVS database schema includes a customer$\_$rental fact table and several dimension tables. The 'customer' table contains customer name and address data. The 'movie' table contains movie title and genre data. The 'order' table contains order date and status data. The 'payment' table contains payment method and amount data. The 'Movie$\_$DistributorCatalogue' table contains distributor name and contact information data. Create SQl CREATE command line for the fact table creation using fields

CustomerID integer NOT NULL,

MovieID integer NOT NULL,

Check$-$outDate date NOT NULL,

Check$-$InDate date NOT NULL,

RentalDue money NOT NULL,

RentalID integer PRIMARY KEY,

RentalStatus char NOT NULL,

CONSTRAINT FKCustomer$\_$ID FOREIGN KEY $($CustomerID$)$ REFERENCES Customer $($CustomerID

and check constraint to evaluate Checkout$\_$date is $>$ check in date