The table below captures data for a small book exchange and book club that you manage. You record the books that members have read as well as the book club that each member belongs to. You want to update your records by using a relational database based on the below business rules.

• A member can borrow more than one book, a book may be borrowed by more than one member.
• A member can only belong to one book club, a book club can have many members.

Your task: Based on the table above create a relational database structure in third normal form (the most appropriate database structure). Identify the Entities and their relevant Attributes, Primary Keys and Foreign Keys. Write your answer in a format similar to the example below:

Table name: attribute name (primary key), attribute name (foreign key/primary key), attribute, attribute name, etc...

(100 words)

Member ID First name Last name Address Book ID Book title Club ID Club name 001 Pa 4566 Leviathan Wakes S1 Michio Roberto 500 Belter Av 4 Madrid St 002 4567 The Terror A1 Carlos Carlos SciFi Adventure Adventure Adventure 002 Roberto 4 Madrid St 5469 A1 002 Roberto 4 Madrid St 4560 1 003 James Carlos Holden Holden 12 Rocin St 4561 T1 Thriller 003 James 4566 T1 12 Rocin St 88 Earth St Project Hail Mary Pride and Prejudice Origin Leviathan Wakes The North Waters Rendezvous with Rama Enemy of All Mankind The Terror 004 Avars Jones 3889 H1 004 Avars Jones 88 Earth St H1 3780 5001 Thriller History History History History 004 Avars Jones 88 Earth St H1 004 Avars Jones 88 Earth St 4567 H1