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
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