SECOND NORMAL FORM

SECOND NORMAL FORM

1. Only if all attributes are completely dependent on the key

2. Description of the second normal form (2 Fn)

   • It must be in first normal form
   • You must have a password composed

3. DESCOMPOSITION

   • This converts a relationship into several subrelationships which each must obey a rules and these rules are described in terms of dependence.

4. PROJECTION

   • The relationships thus formed give us three new ssub-relationships. A subrelation is the relationship that derives from a larger relationship.

5. GRAPHICS

   • It should be noted that this graph is created examined with knowledge and attributes to determine how they participate and They relate to each other.

6. EFFECTS

   • The effect of this decomposition may not result. Half clear. We must insist that none correct relationship must contain duplicate tuples

Bilder und Dateien der Mindmap