A
A
Anton2016-06-09 21:51:43
SQL
Anton, 2016-06-09 21:51:43

What is fourth normal form?

On Habré I read one thing, on another site - another.
I will give an example:
There are tables: employees, employees_positions and employees_and_positions.
The first keeps employees.
The second stores positions.
And the third one brings it all together. Many-to-many.
An employee can have multiple positions. A position can have multiple employees. To whom the logic is now broken - this is normal. This is a rough example. But this moment is not important now. I'm talking about something else.
So. Is it 4nf?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Andrey Burov, 2016-06-09
@BuriK666

fourth normal form

I
iegor, 2016-06-09
@iegor

There is a tuple A, B, C where there is a dependency between A and B and between A and C, but there is no dependency between B and C. In this case, 4NF talks about the need to decompose the base

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question