Answer to Question 1
A
Answer to Question 2
The MySQL Workbench includes a set of buttons that are used to create relationships between two tables. If the tables already contain the appropriate primary and foreign keys, the relationship should be created using the Place a Relationship Using Existing Columns button. If the tables do not have the needed foreign key, use the 1:1 Non-identifying Relationship button, the 1:N Non-identifying Relationship button, the 1:N Identifying Relationship button, the 1:N Identifying Relationship button, or the N:M Identifying Relationship button as appropriate to create the needed relationship. Note that the N:M Identifying Relationship button actually adds an intersection table and two 1:N Identifying Relationships.