title: How to design a database model for a large data warehouse?
body: <p>Lets say I design a database model for an online seller such as Amazon:</p>
  
  <p><img src="https://i.stack.imgur.com/V6f4D.png" alt="enter image description here"></p>
  
  <p>Next, to create the database model for the larger data warehouse, I flatten the Order and OrderDetails tables, and flatten the Product and Vendor tables:</p>
  
  <p><img src="https://i.stack.imgur.com/6WvKG.png" alt="enter image description here"></p>
  
  <p>I do this to apply the concept of designing models for parent-child applications, as described here <a href="http://bit.ly/1bOuOXQ" rel="nofollow noreferrer">http://bit.ly/1bOuOXQ</a></p>
  
  <p>The data in the data warehouse tables becomes repetitive:</p>
  
  <p><img src="https://i.stack.imgur.com/u0HkQ.png" alt="enter image description here"></p>
  
  <p>Several values such as $76.30 for OrderTotal repeat on each row, is this correct?  Is the model correct?</p>