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
How may clustered index we can create in table?
How to register exception filter globally?
Explain login controls.
Explain the boxing and unboxing concept in .net?
Is asp.net a language?
How do you secure your connection string information?
Explain the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What is the difference between the get method () and post method ()?
How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them ?
What is preprocessor in .net?
What does ascx stand for?
Why is this service branded with windows livetm?
Explain the various authentication mechanisms in asp.net.
Describe the difference between inline and code behind - which is best in?
Explain the use of resource manager class in .net.