Exercise 2 Translate the logical schema into a collection of tables. For each table: • Indicate its name and the names of the columns (but not their types). • Underline the columns that are part of the primary key. • Indicate the entity in the ER diagram to which the table corresponds. To make sure you choose the right data types for the columns, you can also check the values in the dataset.

Fig: 1