Relational Database Design and SQL

List the attributes required to capture the data for the entities in a data model using the information provided below.

The data model will hold information relating to a book collection. The following information defines the requirements which the data model must meet.

The entities are as follows:

• Author

• Book

• Publisher

The data model should allow the following questions to be answered:

• Do you have any books by Timothy Findley?

• How many authors live in BC?

• Do you have a hardback edition of Bishops Man?

• What are the current prices for all the books?

• What is the published date for A Fine Balance?

• What is the telephone number for the publisher Penguin Books Canada?