1.

What Are The Common Mistakes That Encounter During Data Modeling Activity, List Them Out?

Answer»

The common mistakes that are encountered during data MODELING ACTIVITIES are listed below:

  1. First and foremost is trying to build MASSIVE data models. The problem with large massive data models is that they have more design faults. The ideal CASE scenarios is to have a data model build which is under 200 table limit.
  2. Misunderstanding of the business problem, if this is the case then the data model that is built will not suffice the purpose.
  3. Inappropriate way of surrogate key usage.
  4. Carrying out unnecessary de-normalization.

The common mistakes that are encountered during data modeling activities are listed below:


Discussion

No Comment Found

Related InterviewSolutions