title: Database: Should tables always be normalized and have primary keys?
body: <p>I have a database storing customer enquiries about products.</p>
  
  <p>The enquiry reference (text), product number (int) and revision number (int) together uniquely identifies a single discussion between sales and customer.</p>
  
  <p>As a result, there are many tables each for a specific detail about a single enquiry, uqniuely idenified by enq, pdt and rev values combined.</p>
  
  <p>The CREATE TABLE does not use any AUTO INCREMENT UNIQUE PRIMARY KEY for any field.</p>
  
  <p>My question is, is this database design acceptable?
  Should tables always be normalized?</p>
  
  <p>Thanks for advise.</p>