When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.