Apply for Zend Framework Certification Training

Mysql





Database Normalization
First Normalization form
    1 - Eliminate duplicate columns from The Table.
    2 - Create separate tables for each group of related data and
          identify each row with a unique column or set of columns(The Primary
          key).
Second Normalization form
     1 - Meet All the requirements of the first normal form.
     2 - Remove subsets of data that apply to multiple rows of a table and place 
           them in separate tables.
     3 - Create relationships between these tables and their predecessors
          through the use of foreign keys.
Third Normalization form
     1 - Meet all the requirements of the second normal form.
     2 - Remove columns that are not dependent upon the primary key.  

< Row Lock In Mysql Range in Mysql >



Ask a question



  • Question:
    {{questionlistdata.blog_question_description}}
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question


Back to Top