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
When we should use and scope of @@identity?
What is Transparent Data Encryption?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Why is sql server log file full?
In which format does an image save in SQL Server database ?
In which files does sql server actually store data?
Explain about integration services of Microsoft SQL server?
Do you know what guidelines should be followed to help minimize deadlocks?
Explain linked server in sql?
How do you handle datasets larger than 50 gb?
List some major differences between triggers and stored procedures?
What is the report builder?
What is #table in sql server?
Define a cross join?
How to get a list of all tables with "sys.tables" view in ms sql server?