When an indirect relationship causes functional dependency it is called Transitive Dependency.
If P -> Q and Q -> R is true, then P-> R is a transitive dependency.
To achieve 3NF, eliminate the Transitive Dependency.
The above table is not in 3NF because it has a transitive functional dependency −
|Movie_ID -> Listing_ID|
Listing_ID -> Listing_Type
Therefore, the following has transitive functional dependency.
Movie_ID -> Listing_Type
The above states the relation <MovieListing> violates the 3rd Normal Form (3NF).
To remove the violation, you need to split the tables and remove the transitive functional dependency.
Now the above relation is in Third Normal Form (3NF) of Normalization.