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
What action plan is preferred if sql server is not responding?
What is the chart in report?
Explain four layers of abstraction microsoft architectured?
which table keeps the locking information? : Sql server administration
What are various limitations of the views?
What are logical/boolean operations in ms sql server?
What is msdb database? : SQL Server Architecture
A trigger can reference objects outside the current database? State true or false.
What is an indexing strategy?
how to invoke a trigger on demand? : Sql server database administration
How to assign new column names in a view?
How to create a dynamic cursor with the dynamic option?
Why we should not use triggers?
Mention the differences between having and where clause.
how you can configure a running aggregate in SSRS?