Guest User

Untitled

a guest
Oct 11th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. The advantage of a normalized database, is its **general-purpose structure**, that is,
  2. on a normalized table we **can execute any type of query** β€”even those that are least expected at the time of database design.
  3. Several Normal Forms (NF) are defined in relational database theory. Identified by a number and the abbreviation NF,
  4. the normal forms with higher numbers are less exposed to anomalies.
  5. The first three Normal Forms were developed by E. F. Codd, and often we say that a table is "normalized" when it is in 3NF, that is,
  6. when the following rules are met:
  7.  
  8. There are no multi-value attributes
  9. There are no non-prime attributes, functionally dependent on a subset of a candidate key
  10. There are no non-prime attributes, transitively dependent on a candidate key
Add Comment
Please, Sign In to add comment