List out different types of normalizations in sql server and explain each of them?
- 1 Answers
- 1002 Views
- I also Faced
- E-Mail Answers
Answer Posted / Arti
The different types of normalization in SQL Server include: 1) First Normal Form (1NF), which eliminates repeating groups and non-atomic values, ensuring that each column contains only atomic values. 2) Second Normal Form (2NF), which eliminates partial dependencies by ensuring that each non-key attribute depends on the primary key. 3) Third Normal Form (3NF), which eliminates transitive dependencies by ensuring that no non-key attribute is dependent on another non-key attribute.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List out the different types of locks available in sql server?
What are the different types of subquery?
How do I find query history in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
what is the difference between openrowset and openquery?
What is the difference between upgrade and migration in sql server?
What is self contained sub query?
what is spatial nonclustered index
What is the difference between for xml raw and for xml auto?
What are wait types?
Equi join and non equi join is possible with sql server?
How can we solve concurrency problems?
What is a coalesce function?
How do I create a trace in sql server?
Can one drop a column from a table?
