There are 2 major design approaches.

1. Normalization: Idea is to generate a set of relational schemas that can store data with unnecessary redundancy and allow easy info retrieval at the same time. Follow a set of rules to transform bad designs into good ones.

2. Entity - Relational Model: The idea is to model an enterprise as a collection of "entities" and "relationships".

   1. Entity: is a thing or an object in an enterprise that is distinguishable from other objects.

      1. Descried by a set of attributes.

   2. Relationship: it is an association among several entities.

   3. Represented by an Entity-Relationship (E-R) diagram.