What is database normalization?
Answer Posted / padmapriya
Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How connect excel to sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain isolation levels that sql server supports?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Can we use where clause with group by?
Explain about builtinadministrator?
List out different types of normalizations in sql server and explain each of them?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to configure and test odbc dsn settings?
How to select all columns of all rows from a table with a select statement in ms sql server?
Explain the use of containers in ssis?
Determine when an index is appropriate?
Define synonym?
What is awe?
What is transaction server consistency?