title: Should an entity map to its own database table?
body: <p>I'm doing some work using Azure and Idea Blade DevForce and I'm wondering what the best approach is in terms of mapping entities to database tables...</p>
  
  <p>Should an entity have its own table in the database? Is there any performance benefit / detriment to doing this?</p>
  
  <p>Say we have an "Order" entity, a "Product" entity, a "Customer" entity and an "Address" entity; what are the pro/cons of mixing these in one table vs. separating them all out? Obviously the db wouldn't be in 3rd normal form if we didn't separate, but does that matter when using MEF / DevForce?</p>
  
  <p>As a second (less-contrived) example, what if we had an "Account" entity and a "User" entity; an account can have many users, but the users can only belong to a single account... That way, putting them all in one table doesn't duplicate any user data, but I (personally) still think this approach is plain wrong. Are there any reasons why it would be a benefit?</p>