Produce the entity-association model for the following situation, the model should follow the instructions seen in class: A chain of cinemas wants to store information on films showing and having previously been showing in their theaters. We want to be able to store for each of the films: the name, the name of the director of the film, the year of release and the type of film (action, comedy, ...), a film can have more than one type. The chain also has several branches (cinema), which we want to be able to store name and city for each. A branch is showing several films and always have at least one showing at all times. The channel also wants to be able to store the profit that each film brings to each specific branch. Finally, each of the branches employs several employees. We want to be able to store their social insurance number, full name and address. Of moreover, each employee can only be employed at one branch. Finally, we also want to be able to search for employees according to their position. in the branch, there are several types of positions (manager, customer service, etc.)

Produce the physical diagram from your answer to question 1, the diagram must follow the instructions seen in class.