Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Need help with this debug! // Suppose you sell rare first edition books. The price is based on the condition. // Your data is stored

Need help with this debug!

// Suppose you sell rare first edition books. The price is based on the condition.

// Your data is stored in the following table. Create needed tables so this collection is in 3NF.

bookId

title

author

countryOforigin

condition

price

1110

The Count of Mont Cristo

Dumas

France

1

100.00

1111

Nicholas Nickelby

Dickens

England

2

75.00

1112

War and Peace

Tolstoy

Russia

2

75.00

1115

The Three Musketeers

Dumas

France

1

100.00

1117

Great Expectations

Dickens

England

2

75.00

1129

Anna Karenina

Tolstoy

Russia

1

100.00

1234

1984

Orwell

England

3

50.00

1245

The Scarlet Letter

Hawthorne

United States

2

75.00

1310

A Tale of Two Cities

Dickens

England

3

50.00

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_2

Step: 3

blur-text-image_3

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

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students explore these related Databases questions