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