List four common design problems when creating databases from existing data.

List four common design problems when creating databases from existing data.

Creating databases from already existing data may have all or some of the following issues.

  1. There are issues of having multiple attributes.
  2. The structure of database may not be consistent with some values.
  3. There could also be some values that are required but are missing.
  4. General Purpose remark column is also a design problem in creating database from an existing data.