Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Control Theory And Finance

Authors: Andrey Sarychev, Albert Shiryaev, Manuel Guerra, Maria Do Rosário Grossinho

2008th Edition

3540695311, 978-3540695318

More Books

Students also viewed these Finance questions