ABC Entertainment wants a database to track what is playing or has played on each screen in each theater of their chain at different times of the day. Giving a relational database schema as follows:

THEATER (TheaterID, Name, Location)

Description: each theater contains one or more advertising screens for viewing in various movies. Each theater was identified by a theater ID and described by a theater name and location.

MOVIE (MovieID, Title, Duration, Type)

Description: each movie is identified by an ID and further described by its title, duration, and type (i.e., trailer, feature or commercial).

TIMESLOT (TimeSlotID, StartTime, EndTime)

Description: every time slot identified by a time slot ID, start time and end time of that time slot.

ADVERTISEMENT (ID, MovieID, TimeSlotID, TheaterID, AdvDate, AdvPrice)

Description: Movies are scheduled for showing on advertising screens in time slots each day at the specific theather. In each time slot, one or more movies are shown. There is also a need to record advertising price charged for attendance of the movie in that time slot (AdvPrice).

Question:

List the movies (MovieID, Title) which showed on advertising screens in ‘Pearl Plaza’ theater (Name = ‘Pearl Plazar’) on ‘01/01/2021’. The result will not show duplicate movies