What is database normalization?
Answer Posted / shruti
Normalization is the process of breaking tables of a
database into smaller tables and defining relations between
them to make them more flexible, efficient and to remove the
modification anamolies from the database.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What are the basic functions for master, msdb, model, tempdb databases?
What is sql server profiler?
What is Federation and Federation Member?
What is the difference between resultset and resultsetmetadata?
What is the difference between value type and reference type?
How do I create a stored procedure in sql server?
How to create a new schema in a database?
What is collation sensitivity? Explain different types.
what are triggers? : Sql server database administration
What are the differences between left join and inner join in sql server?
What is the difference between DATETIME2 and DATETIME?
Where cross join is used?
How to generate create table script on an existing table in ms sql server?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration