what is normalization?
what is denormalization?

Answer Posted / chethan sy

Normalization is a process of removing redundancy from the
tables.

De-normalization is introducing redundancy.

Is This Answer Correct ?    41 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

last function used in MS Access to convert sql what function will use in sql

1821


Can I work with several databases simultaneously? : sql server management studio

735


What do you understand by hotfixes and patches in sql server?

689


Which are new data types introduced in sql server 2008?

808


How to implement service broker?

701






What are the database objects? : SQL Server Architecture

701


What's the information that can be stored inside a bit column?

709


What are the different types of collation sensitivity in sql server?

774


What is 4nf in normalization form?

756


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

802


What is the use of floor function in sql server?

725


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2253


Differentiate between ms sql server reporting services vs crystal reports?

655


What is the web service used for reporting services?

106


What are different types of data sources?

647