4.22 > DB normalization, etc.

4.22 > DB normalization, etc.

results overview & presentation of Actualities > results

  • 1st   Task | WP + descr.; 1st Actuality (WP) /publ. + present./
  • 2nd Task | Techn.: 2nd Actuality (php;mysql ..); 10 act.queries; PHP script + agent; PHP-MySQL junct. + interface /publ. + demo/
  • 3rd  Task | DB plan + DB demo /processed/

3rd task /DB planning & demo/ lectures&practices

  • DB Project Theme selection
  • Simple (one Table) DB planning & realisation  > 4.08 
    • DB plan creation
      • plan should be argumented and everything in it should be based on DB requirements
        • DB requirements > req. analysis > conceptual DB model > relational DB model
    • DB plan realisation (with phpMyAdmin, etc.) & demo
  • More complex (with related Tables) DB planning & realisation  > 4.15
    • DB plan creation > publishing & presentation
      • plan should be argumented and everything in it should be based on DB requirements
        • DB requirements > req. analysis > conceptual DB model > relational DB model
    • DB plan realisation (with phpMyAdmin + PHP-MySQL interface) > publishing & demo
      • Information input & output (including multi table queries)

=========================================================================

DB normalization > slides, DB sol. / for more sources > e.g., here /

  1. Questions
    • What problems are solving during DB normalization?
    • What are principles of DB normalization?
    • What are rules of DB normalization?
    • Describe normalization forms.
  2. DB normalization forms
    • Ist normal form?
      • Atomic?
        • Your example? /address/
    • 2nd normal form?
      • Full dependence from Primary Key?
        • Your example? /’studies’/
    • 3rd normal form?
      • Functional dependence
        • Example? /X->Y/
      • Transitive dependence
        • Example? /If X->Y and Y->Z, then X->Z/
    • Other normal forms? /after conversion concept. model into relational -> 4th normal form/
      • ..
  3. Example of normalization process
    • Database ‘studies’
      • Table ‘studies’ > st.id | st.name | group | faculty | address | sb.id | sb.name | credits | lect. | exam.eval |
        • let’s normalise it