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 |
Is iis a web server or an application server?
How do I check iis logs?
How do you create Virtual Root in IIS?
Where are iis backups stored?
What is net start command?
Where is iis manager located?
How do I start and stop iis?
What are the Advantages in IIS 6.0?
What is iis on windows 10?
What is App Pool in IIS?
Can you run iis on linux?
Can I run multiple websites with same port number and different IP address?
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)