C(4.6) Adding Projects: Not a good example of data redundancy

[ricayanzon]

The example doesn't really show why data is redundant, but why data integrity can be lost. These are two different concepts and I think a more precise example would be nice here.

It is already mentioned that we would need to store the project id and name for every task, so I would continue that example: As the objects become larger, e.g. you add multiple fields like startDate, endDate, description, status, deadlines, ... to your projects, then all of this information must be stored for each task (each task being a row in the Task table). But because all tasks belong to the same project, the exact same project data would be stored multiple times. For example, if we have 3 tasks in the same project, Project 1, each task would store name, id, startDate, endDate, description, status, deadlines, ... of Project 1.