title: Is creating a "dummy record" to force data-base obey the business logic, a good idea or a dumb one?
body: <p>In some projects I see that a dummy record is needed to create in Db in order to keep the business logic go on without breaking the Db constraints.</p>
  
  <p>So far I have seen its usage in 2 ways: </p>
  
  <ul>
  <li>By adding a field like IsDummy</li>
  <li>By adding a field something called ObjectType which points a type: Dummy</li>
  </ul>
  
  <p>Ok, it helps on what needs to be achieved. </p>
  
  <p>But what makes me feel alert on such solutions is sometimes you have to keep in mind that some dummy records exist in the application which needs to be handled in some processes. If not, you face some problems until you realize their existence or until someone in the team tells you "<em>Aha! You have forgotten the dummy records. You should also do...</em>" </p>
  
  <p><strong>So the question is:</strong>
  Is it a good idea to create dummy records to keep business logic as it is without making the Db complain? If yes, what is the best practice to prevent developers from skipping their existence? If not, what do you do to prevent yourself from falling in a situation where you end up with an only option of creating a dummy record?</p>
  
  <p>Thanks!</p>