1
I have a super badly made table in my hands and I need to normalize this up to 2FN. Can someone give me some tips? I am not being able to apply the theory in this table. Here is a sample of it: (the attribute "city" is repeated although in this sample it is not repeated)
We need to understand the problem to steer better. Without a detail it might be suitable. Of course there are things that look bad, but only if we know the requirements.
– Maniero
A relation is in the second normal form (2FN) if and only if it is in the first normal form (1FN) and does not contain partial dependencies. Therefore you need to initially ask about the first normal form and check if your tables are normalized.
– Rafael Salomão
I didn’t understand what you were getting at, but this is a table of events held in Portugal. In "original designation" is the name of the event, and the rest of the attributes I think you can see
– Carrilho
As @Maniero said above, you need to improve the question and show all existing entities in the database. In addition, it would be necessary to check that their tables are normalized in the first normal form; in other words, there are fields containing compound values, which would generate other entities. As the second normal form needs the first normal form (1FN) necessarily, you need to provide more details in your question.
– Rafael Salomão
A practical example of what I am saying is the attribute "Specific term" contained in your table, note that the assigned values are composed of "Culture and Leisure" if the system needs to research part of this value or is to search only for Culture or only by Leisure this table would not respect the first normal form (1FN) this case depends specifically on the rules of business, since it is not in the first normal form will never be in the second.
– Rafael Salomão
But the value does have that name, and you can’t decompose the same
– Carrilho
With all due respect to a guy who used to be my boss your problem is "gaseous" ...
– Motta
@Carrilho In my opinion, we have to take into account the definition that Rafael Salomão left, of not being in 1FN and not containing partial dependencies. Then we have that its Designation defines the duration and the periodicity; District defines city; and the key terms define the current terms that define the specific terms. By defining, I say that these would become tables of their own. Then I would move to 3NF and remove the transitive dependencies. Since all data are atomic, this table is already in 1FN.
– Pantoja