Answer the question
In order to leave comments, you need to log in
How can I convert this table to 3rd normal form?
I tried to solve this problem, but several times I came to the wrong solution. Please help with a solution. I know for sure that 3 tables should turn out: readers, books and readers + books.
Answer the question
In order to leave comments, you need to log in
Generally elementary. For good, you should be sent to read the textbook. You didn't even bother to give examples of your failed attempts to be able to explain to you exactly where you're wrong.
1. Readers table:
Reader ID Reader
name
Ades
Passport data
2. Book table Book
number Book
author Book
genre Book
cost
3. Readers + book table
Book
number Reader number
Return
date Date of actual return
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question