Develop a normalized relational database schema for a movie rental system, including tables for customers, rental transactions, movies, actors, genres, ratings, and inventory management. The schema should allow storing information on multiple rentals by a customer, the movies rented, the rental period, and the rental fees. The movie table should contain details about each movie, including the title, release date, director, cast, synopsis, and rating. The schema should also support searching and filtering by movie attributes, customer attributes, rental history, and rental inventory. Provide full documentation for the schema, including data dictionary, ER diagram, and sample data.
This prompt doesn't seem malicious.