1.(15 marks) Given the ER diagram of a MOVIES database of Figure B.1, answer the following questions with this diagram. M N PERFORMS_IN AName MName MOVIE ACTOR LEAD ROLE 1 2 N 1 ALSO A DIRECTOR ACTOR PRODUCER N DName- 1 1 DIRECTOR DIRECTS PName M N PRODUCER PRODUCES Figure B.1: ER diagram for a MOVIE database Write the relational database schema for MOVIE including (1) all the entities with attributes (11) all relationships with attributes, (111) one referential integrity (foreign key) constraint using the relationship DIRECTS; your answer should indicate both the referencing attribute and the referenced attribute, (iv) explain the cardinality constraint (from left to right and from right to left) for the relationship 'DIRECTS' entities (e.g., indicating how records in an entity relate to another entity (is it 1:N or something else?)). (v) explain the participation constraint (total or partial) for the relationship DIRECTS'. 4