F
F
FlyServer2021-10-10 13:27:29
Database design
FlyServer, 2021-10-10 13:27:29

Are full name and passport data dependent attributes?

There is a table for describing employees.

Table attributes:
Code (primary key)
Full name (Last name, First name, Patronymic)
Passport data (Series, Number)
Position
Phone The

database was normalized. The third normal form assumes the elimination of interdependent non-key attributes from the table by separating them into a separate table.
The question is - are the non-key attributes Full Name and Passport Data interdependent attributes in this case?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Adamos, 2021-10-10
@FlyServer

You talk too much instead of thinking.
The correctness of data storage is determined by the convenience and optimality of their use .
If you have statistics that will be used to build the frequency of using the name Evgeny among people with a surname of Armenian origin, you can even normalize for each element of the full name.
And if this data is simply stored in order to display it somewhere in one go, and even a search is never done on it, they can generally be a single JSON field.
But these are, of course, extremes. Usually it is enough not to be smart and make a flat table with the available data and not make false assumptions like "a person can only have a single full name" or "only one passport is relevant at a given time."

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question