Interested to Buy Any Domain ? << Click Here >> for more details...
what is normalization?
what is denormalization?
- 9 Answers
- 35078 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / koti
In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. 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.
De-normalization is introducing redundancy.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
How self join is different from outer join?
How to recompile stored procedure at run time?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Is ssrs support other database except ms sql server?
How do I view a script in sql server?
How to get all stored procedures in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
How to start sql server browser service?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is the difference between clustered and a non-clustered index?
Explain about Normalization?
How to download microsoft sql server 2005 express edition?
Explain external key management in sql server 2008
Define Unique Key?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
