Question: 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

The table below captures data for a small book

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. Last_name Club ID Club_name SciFi Pa Carlos Carlos Member ID First_name 001 Michio 002 Roberto 002 Roberto 002 Roberto 003 James Address 500 Belter Av 4 Madrid St 4 Madrid St S1 A1 4567 A1 Adventure Adventure Adventure 4 Madrid St A1 Carlos Holden Book_ID Book_title 4566 Leviathan Wakes The Terror 5469 Project Hail Mary 4560 Pride and Prejudice 4561 Origin 4566 Leviathan Wakes 3889 The North Waters 3780 Rendezvous with Rama 5001 Enemy of All Mankind 4567 The Terror Thriller T1 T1 003 Holden James Avars 004 H1 12 Rocin St 12 Rocin St 88 Earth St 88 Earth St 88 Earth St 88 Earth St Jones Jones Jones Jones 004 Avars 004 Avars 004 Avars H1 Hi H1 Thriller History History History History 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!