please explain Nomalization in dbms?

Answer Posted / ankit srivastava

Normalization is the technique that removes redundancy in
table.It ensures that there is no any duplicate data in table.

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you copy a database?

492


8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1521


What is an example of a database?

472


Is declare cursor executable?

529


What is advantage of dbms?

554






Can we save file in database?

483


Why is the use of dbms recommended?

629


Why does reading require write privileges on database file?

483


What are the two major subsystems of system r?

645


Can we linked SharePoint to a SQL databasebe?

581


What is distributed queries?

525


How is foreign key commands related to primary key?

443


What are the 3 types of relationships in a database?

468


What are the different levels of abstraction in the dbms?

461


Why do we need database management?

483