What is normalization? Explain normalization types.
Answers were Sorted based on User's Feedback
Answer / ashishonline12345
Database normalization is the process of changing a
relational database structure to be the most efficient for
the particular purpose. The most commonly known form
is “Third Normal Form”, which allows for zero duplicate
data, except for foreign keys.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / guest
Database normalization is the process of organizing the
fields and tables of a relational database to minimize
redundancy and dependency. Normalization usually involves
dividing large tables into smaller (and less redundant)
tables and defining relationships between them. The
objective is to isolate data so that additions, deletions,
and modifications of a field can be made in just one table
and then propagated through the rest of the database via the
defined relationships.
1 NF:Normal Form
2 NF
3 NF
BCNF - Boyce Code Normal Form
5 NF
6NF : Impossible to achieve this level of normalization
| Is This Answer Correct ? | 4 Yes | 1 No |
How do I create a virtual directory in iis?
What is iis worker process?
Why do we need to recycle application pool?
What are the different security settings available in iis?
IIS services ?
In which process does IIS runs (was asking about the EXE file) ?
What is App Pool and App Domain? What is the difference between the two.
What are the Advantages in IIS 6.0?
What is iisreset command?
How do I check the version of iis?
How do I reset iis in windows 7?
How many authentications are done on IIS? Port numbers for HTTP? How do you take backups of IIS Servers...IBM Questions.
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)