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 |
IIS Migration ?
How do I enable iis logging in event viewer?
What is app domain?
How do I stop all iis services?
portno for HTTP & HTTPS
What services does iisreset restart?
What are virtual directories in iis?
Why iis is used?
What are the iis versions?
Exp the different types of identity available in iis 6.0?
What is the use of virtual directory in iis?
How do I stop and start iis?
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)