QUESTION 1

1. The Entity Relationship Diagram below shows the logical design of a database for books and authors.

   Based on the Entity Relationship Diagram answer the following questions:

   1a. How many Entities are there?

   1b. In the current structure which table requires a Composite Primary Key/Foreign Key?

   1c. A Genre can have a maximum of how many Books?

   1d. Which table is a Linking Entity?

   1e. Where is a Linking Entity needed?

   1f. A Book can have a maximum of how many Genres

Author Genre Author_id Genre_id First_name Genre Last_name Address Date_of_birth Book Book_Author ISBN ISBN > Title Author_id Author id Genre_id Award Award_id Award_title