Database Designing

• MySQL use the alpha numeric character .
• MySQL limited the 64 characters . 
• MySQL use the underscore (_) to separate word.
• MySQL is entirely lowercase word .
• MySQL use the plural table name to indicate multiple value store  and singular column names .

Second normal Form
You can achieve the Second Normal Form only then when your table must meet the First Normal Form with its entire requirement. As you seen the First Normal Form works with only atomicity of data, but Second Normal Form deals with the relationships of tables between composite keys and non-key columns. In Second Normal Form subset of data is removed, and its apply to multiple rows of a table and then place them in separate tables.
    
Third Normal Form
You can achieve the Third Normal Form only then when your table must meet the Second Normal Form with its entire requirement. In Third Normal Form, all columns must be directly depended on the primary key means remove the column, which is not dependent upon the primary key.
    
Boyce - Codd Normal Form
You can achieve the Boyce - Codd Normal Form only then when your table must meet the Third Normal Form with its entire requirement. In Boyce - Codd Normal Form every non-trivial functional dependency must be a dependency on a superkey. 
     
Fourth Normal Form
You can achieve the Fourth Normal Form only then when your table must meet the Boyce - Codd Normal Form with its entire requirement. Fourth Normal Form confirmed you that the independent multivalued facts are efficiently and correctly represented in database design.