Question: QUESTION 2 6 points Save AA The table below captures data for a small book exchange and book club that you manage you record the

QUESTION 2 6 points Save AA The table below
QUESTION 2 6 points Save AA 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 Amber can only belong to one book club, abok du can have many members Member ID First name 001 Michio 00 Roberto Roberto Lam Pa Carios Cu Carles Hold Holm Club ID ST AI AL AI Address 500 Bellery 4 Mad 4 Madrid 4 Mid 12 Reis 12 los th BE Earth Farth St Book ID Book title 4566 Levia Wiki 4367 The S Project May 360 juice 4561 One 1560 Latan 14.44 In Nhanh Nhi 3780 Radeou will SO01 All Mankind 4862 The Terror Oub Scil Advent Aber A Thrille Thilla James 0 m TE Avis 04 A 504 Avans lon ories loor 1 HI HI HI HI Histor Your task: Based on the table to create a relational database structure in third normal form (the most appropriate database strutture identify the Entities and their relevant Attributes Primary keys and Foreign Keys. Write your answer in a forma similar to the example below Tatle name: attribute name primary keyleriterane for krypimary key attribute, attribute rame 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!