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 a program using razor view engine to create a simple application? : asp.net mvc
What is is post back property in asp net?
What is a postback ispostback and autopostback in asp net?
What is a response cookie?
How would you create a permanent cookie?
Contrast OOP and SOA. What are tenets of each ?
What is work flow gen? how can it will work with .Net?
What is application variable in asp.net?
What is the difference between application state and session state in asp net?
Should I delete cookies?
What are the properties of the eventargs argument when capturing keyboard events?
What is the difference between session and viewstate?
What is break mode?
Which methods validate all the controls on a page?
What is the difference between session.abandon() vs clear()?