How many tables will be in the database so that it corresponds to the 3rd normal form?

D

Dmitry2014-01-09 17:01:27

Database

Dmitry, 2014-01-09 17:01:27

We need a full-fledged database to store and process three entities, for example - books, authors of books, stores that sell books. How many tables will be in such a database so that it corresponds to the 3rd normal form ?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

R

Rsa97, 2014-01-09
@another_dream

If all you need is the name of the author, the title of the book and the name of the store, then 5. `Books`, `Authors`, `Stores`, `Authors_of_books`, `Books_in_shops`. The last two tables define a many-to-many relationship.