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 open iis manager?
How do I install and configure iis?
Why do you need iis?
Describe the different types of identity available in iis 6.0?
find the script to recycle application pool in iis in specific interval?
What is appdomain in iis?
How to open iis configuration manager?
What is App Pool and App Domain? What is the difference between the two.
How do I get to iis?
What is the difference between the app pool and app domain in iis?
How iis recognize that web application is developed in which language? 6) How iis will use authentication? 7) Is it pages will compile in server? 8) In server pages will compile or execute? 9) What is diff between compile and execute?
How do you know if iis is running?
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)