⟩ What is sufficient to normalize a database up to 3NF?
dependent on application. Most transactional based
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.