How can I convert this table to 3rd normal form?

H

hibrissy2021-11-07 13:31:21

Database design

hibrissy, 2021-11-07 13:31:21

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.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

S

Sergey Vodakov, 2021-11-07
@WaterSmith

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

S

Sergey _, 2021-11-07
@SiteCenter

Variant for three tables: