A normalized relation can still suffer anomalies. Going the other way, which (if any) normal forms can be violated by a relation that's free from anomalies? If such exist,
- For each such normal form that can be violated, what is an example of an anomaly free relation that violates the normal form?
- Are there any normal forms that an anomaly free relation is guaranteed to comply with?