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

$$ MovieID integer NOT NULL,

$$ Check$\_$outDate date NOT NULL,

$$ Check$\_$InDate date NOT NULL,

$$ RentalDue money NOT NULL,

$$ RentalID integer, rentalstatus char and dimesion table forigenkeys and check constraint to evaluate Checkoutdate is $>$ check in date