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

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

Following are the four common design problems when databases are created from existing data:

  1. The multivalue, multicolumn problem
  2. Inconsistent Values: There are values that are inconsistent with regards to the overall structure of the database.
  3. Missing Values: Some required values might be missing.
  4. General-purpose remarks column