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

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!