A cinema club shows up to three screenings of films on a given day. They need a database to keep track of which films have been shown on which dates. It has been suggested that they use one table (relation) about the films they show, which will hold the following data:

FilmID, Title, Duration, Male Lead, Female Lead, Date shown, Time shown, Tickets sold

pur-new-sol