I'm studying a DB course and I found this table:
In this exercise, the objective is to determine whether the table has redundancy or not.
According to the definition of redundancy
Data redundancy occurs in database systems which have a field that is repeated in two or more tables
Redundancy DOES exists in the table,FECHA_INICIO(START_DATE) and FECHA_FIN (END _DATE) attributes, but should this attributes be considered as redundant?
Dates are quite volatile and I'm not quite convinced that those columns should be treated as redundant?
Any ideas on whether this table contains redundancy or not?