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 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 | Project Hail Mary | A1 | Adventure |
002 | Roberto | Carlos | 4 Madrid St | 4560 | Pride and Prejudice | A1 | 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 |
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started