H
H
hibrissy2021-11-07 13:31:21
Database design
hibrissy, 2021-11-07 13:31:21

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

6187a8f0e27b1492550482.png
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

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:
6187bc4cdc653352977445.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question