title: Dimensional vs Transactional Database?
body: <p>Trying to learn more about databases/data warehouses and am getting confused about the different terminology. What is the difference between a dimensional database and a transactional database? Is a transactional database the same as an operational database? </p>
  
  <p>From what I've gathered a dimensional database is in a star schema and is made of fact tables with foreign keys and dimension tables with those foreign keys as primary keys. </p>
  
  <p>Trying to understand how OLAP, RDBMS, T-SQL, etc and all of these other terms fit in. </p>
  
  <p>Please explain as if I'm 5. </p>