What is normalization and what are the five normal forms?

COBOL SQL Interview Questions

(Continued from previous question...)

What is normalization and what are the five normal forms?

Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy.

(Continued on next question...)

Other Interview Questions

• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?
• Where in a table are added column located ?
• What is the meaning of underscore ...
• What is a cursor? Why should it be used ?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• What is the syntax for a CREATE TABLE statement ?
• Can one add columns to a table after it has been defined?
• What authority is required to create a table?
• What is referential integrity?
• More...