Section B (35 marks): This section has 3 questions: 1. (15 marks) Given the ER diagram of a MOVIES database of Figure B.1, answer the following questions with this diagram. N M PERFORMS_IN AName MName MOVIE ACTOR LEAD_ROLE 2 N ALSO A DIRECTOR ACTOR PRODUCER DName 1 DIRECTOR DIRECTS PName M PRODUCER N PRODUCES Figure B.1: ER diagram for a MOVIE database Write the relational database schema for MOVIE including (1) all the entities with attributes, (ii) all relationships with attributes. (iii) 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'. MOVIE Database MOVIE SCHEMA for the Database Component Component Entities with attributes (1) (5 marks) 11) Relationships with attributes (5 marks) 111. iv. (iii) one referential integrity(foreign key) constraint using the relationship DIRECTS', which indicates both the referencing attribute and the referenced attribute, (1.5) (iv) explain the cardinality constraint (from left to right and from right to left) for the relationship DIRECTS' entities. (1.5 marks). V. (v) explain the participation constraint (total or partial) for the relationship 'DIRECTS