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

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 Finance Questions!