title: Steps to design a well organized and normalized Relational Database
body: <p>I just started making a database for my website so I am re-reading <code>Database Systems - Design, Implementation and Management (9th Edition)</code>but i notice there is no single step by step process described in the book to create a well organized and normalized database. The book seems to be a little all over the place and although the normalization process is all in one place the steps leading up to it are not. </p>
  
  <p>I thought it be very usefull to have all the steps in one list but i cannot find anything like that online or anywhere else. I realize the answerer explaining all of the steps would be quite an extensive one but anything i can get on this subject will be greatly appreciated; including the order of instructions before normalization and links with suggestions.</p>
  
  <p>Although i am semi familiar with the process i took a long break (about 1 year) from designing any databases so i would like everything described in detail. </p>
  
  <p>I am especially interested in:</p>
  
  <ul>
  <li>Whats a good approach to begin modeling a database (or how to list business rules so its not confusing) </li>
  </ul>
  
  <p>I would like to use ER or EER (extended entity relationship model) and I would like to know</p>
  
  <ul>
  <li>how to model subtypes and supertypes correctly using EER(disjoint and overlapping) (as well as writing down the business rules for it so you know that its a subtype if there is any common way of doing that) </li>
  </ul>
  
  <p>(I allready am familiar with the normalization process but an answer can include tips about it as well)</p>
  
  <p><strong>Still need help with:</strong></p>
  
  <ul>
  <li>Writing down business rules (including business rules for subtypes and super types in EER)</li>
  <li>How to use subtypes and super-types in EER correctly (how to model them) </li>
  </ul>
  
  <p>Any other suggestions will be appreciated. </p>