Answer Posted / mithun
Normalization is a process of organizing data in databased, which includes creating tables and establishing relationship between them.
1st Normal Form - Do not use multiple fields to store same data.
Eliminate repeating groups in individual tables.
Create a separate table for each set of related data.
Identify each set of related data with a primary key.
2nd Normal Form - Records should not depend on anything other than a table's primary key.
Create separate tables for sets of values that apply to multiple records.
Relate these tables with a foreign key.
3rd Normal Form - Eliminate fields that do not depend on the key.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is custom events? How to create it?
What is the difference between custom web user control and a custom web server control?
What do you mean by caching in asp.net?
What is the concept of view state in asp.net?
Define application state variable and session state variable?
What is a web api? Which protocol is used in a web api?
How to you can limit Access to Web API to Specific HTTP Verb?
How to implement form based authentication in asp.net application?
What is Bundling and Minification in MVC?
Is asp net front end or backend?
Explain State management in asp.net
How much is the pay-for-use service if I chose not to use microsoft-sponsored advertising?
What is data caching?
Do you know about caching with the datasource controls?
What are session state modes? List some of the important session state modes of asp.net.