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
Explain the function of new view engine in asp.net? : asp.net mvc
What is intrinsic objects in asp.net?
What is the purpose of session management?
What is the difference between web config and machine config files?
What is routing in MVC?
What are Caching techniques in .NET
Which method is used to enforce garbage collection in .net?
Where is the view state data stored in asp net?
How can you handle errors in Web API?
To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?
Explain the use of view state?
Explain how caching in asp.net 2.0 is different from caching in asp.net 1.1?
How to add DateTime Control in normal DataGrid Server Control?
What is the difference between exe and dll?
How do I force the dispose method to be called automatically, as clients can forget to call dispose method?
