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...
 

Transcribed Image Text:

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

Answer rating: 100% (QA)

Entities and Attributes 1 Members Member ID Primary Key First Name ... View the full answer